学生成绩管理系统

┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊目录一设计目的 (1)二设计内容 (1)三设计要求 (1)四设计过程 (1)1 任务解析 (1)2 程序结构分析 (3)3 数据结构分析 (3)4 功能实现 (3)5 系统测试 (3)五设计总结 (6)参考文献 (7)附录 (7)┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊一设计目的建立学生成绩管理系统，采用计算机对学生成绩进行管理，进一步提高办学效益和现代化水平。

帮助广大教师提高工作效率，实现学生成绩信息管理工作流程的系统化、规范化和自动化。

二设计内容（1）题目分析，查找资料和总体设计。

（2）详细设计、代码编制、程序调试。

系统功能要求如下：①具有登录功能②具有职工工资的录入功能③具有数据查询、删除、修改功能④具有输出功能⑤具有统计功能（3）结果分析、完成课程设计说明书。

三设计要求（1）只能使用Java语言，采用面向对象方法进行设计，要求使用结构体数组或链表编写程序，源程序要有适当的注释，是程序容易阅读。

（2）程序的界面、逻辑功能和数据的存储尽可能的分开，至少采用文本菜单界面（如果能采用图形菜单界面更好）。

（3）学生可根据自身情况酌情增加新功能（视情况可另外加分）。

（4）独立完成课程设计，并完成课程设计报告，报告应记录设计的过程，尤其是分析/设计/实现过程中的决策。

四设计过程1 任务解析（1）实体及其属性图如图1至5所示。

图1课程实体及其属性图┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊图2教师实体及其属性图图3学生实体及其属性图图4学生成绩实体及其属性图图5登录系统的用户实体及其属性图┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊2 程序结构分析图2-1 管理员管理流程图3 数据结构分析表1登录表表4-9教师信息表结构┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊表4-10学生信息表结构表4-11课程信息表结构4 功能实现将用户输入的名称及密码和数据库中用户管理表中的名称及密码进行比较，相同则可以进入系统的主窗体。

否则出现密码出错提示，由下面的代码来提示用户所输入的密码有误。

通过以下语句来实现。

public void widgetSelected(final SelectionEvent e) {JDBC j = new JDBC();String sql = "select * from 密码表";ResultSet rs = j.query(sql);try {while(rs.next()){name = text.getText();if(text.getText().equals(rs.getString("用户名"))&&text_1.getText().equals(rs.getString("密码"))&&combo.getText().equals("管理员")){tag = true;title = "管理员";login.this.dispose();System.out.println("go");return;}else if(text.getText().equals(rs.getString("用户名"))&&text_1.getText().equals(rs.getString("密码"))&&combo.getText().equals("学生")){System.out.println("=========================");tag = true;title = "学生";login.this.dispose();System.out.println("do");return;}else{┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊label_3.setForeground(SWTResourceManager.getColor(255, 0, 0));label_3.setFont(SWTResourceManager.getFont("黑体", 10, SWT.NONE));label_3.setText("您的输入有误！");label_3.setBounds(557, 340, 98, 27);System.out.println ("stop");//return;}}} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}}5 系统测试（1）登陆界面（2）学生查询界面（3）添加学生信息界面┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊五设计总结本次课程设计，让我获益匪浅，不仅更深入的了解Java这门学科，更使自己有了继续探索的兴趣。

于个人而言，在程序设计的过程中，我深感“认真严谨”这个词的重要性，一点点小的马虎，便会导致整个程序不能正常运行。

在今后的学习中，我定将“认真严谨时刻作为自的谨言。

与此同时，本小组成员的互帮互助，让我体会到了团结的力量，而更让人难以忘怀的是在热烈讨论问题时，那激情横溢的场面。

总之，此次课程设计在我的学生生涯中启上了至关重要的作用。

最后，真诚的感谢陈珂、顾成喜老师的指导和教诲。

┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊参考文献1)《Java 程序设计之网络编程》，李芝兴主编，清华大学出版社2)《Thinking in JAVA(Third Edition)》,Bruce Eckel,机械工业出版社3)《Java 2核心技术（第6版）卷I：基础知识》,Cay S.Horstmann,Gary Cornell,程峰等译,机械工业出版社4)《Java2参考大全（第四版）》，[美]Herbert Schildt著，张玉清、吴浦峰、尚勇等译，清华大学出版社┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊附录1.登陆界面package登录;import java.sql.ResultSet;public class login extends Shell {private Text text_1;private Text text;private Combo combo;public static String title ;public static String name;public boolean tag;/*** Launch the application* @param args*/public static void main(String args[]) {try {Display display = Display.getDefault();login shell = new login(display, SWT.SHELL_TRIM);shell.open();yout();while (!shell.isDisposed()) {if (!display.readAndDispatch())display.sleep();}} catch (Exception e) {e.printStackTrace();}}/*** Create the shell* @param display* @param style*/public login(Display display, int style) {super(display, style);createContents();setBackgroundImage(org.eclipse.wb.swt.SWTResourceManager.getImag e("G:\\\u56FE\u7247\\3F5KBDC[8RTF@E)5HL{O{7I_\u526F\u672C.jpg"));}┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊/*** Create contents of the window*/protected void createContents() {setText("数字化校园平台");setSize(655, 449);final Label label = new Label(this, SWT.NONE);label.setFont(SWTResourceManager.getFont("黑体", 12, SWT.NONE));label.setText("用户类别：");label.setBounds(170, 183, 67, 22);final Label label_1 = new Label(this, SWT.NONE);label_1.setFont(SWTResourceManager.getFont("黑体", 12, SWT.NONE));label_1.setText("用户名：");label_1.setBounds(170, 238, 67, 22);final Label label_2 = new Label(this, SWT.NONE);label_2.setFont(SWTResourceManager.getFont("黑体", 12, SWT.NONE));label_2.setText("密码：");label_2.setBounds(170, 286, 67, 22);combo = new Combo(this, SWT.NONE);combo.setItems(new String[] {"学生", "管理员"});combo.setBounds(280, 181, 154, 24);text = new Text(this, SWT.BORDER);text.setBounds(280, 236, 155, 24);text_1 = new Text(this, SWT.BORDER | SWT.PASSWORD);text_1.setBounds(280, 296, 157, 25);final Label label_3 = new Label(this, SWT.NONE);final Button button = new Button(this, SWT.NONE);button.setText("登录系统");button.addSelectionListener(new SelectionAdapter() { public void widgetSelected(final SelectionEvent e) { JDBC j = new JDBC();String sql = "select * from 密码表";ResultSet rs = j.query(sql);try {while(rs.next()){name = text.getText();if(text.getText().equals(rs.getString("用户名"))&&text_1.getText().equals(rs.getString("密码"))&&combo.getText().equals("管理员")){tag = true;title = "管理员";login.this.dispose();System.out.println("go");┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊return;}else if(text.getText().equals(rs.getString("用户名"))&&text_1.getText().equals(rs.getString("密码"))&&combo.getText().equals("学生")){System.out.println("=========================");tag = true;title = "学生";login.this.dispose();System.out.println("do");return;}else{label_3.setForeground(SWTResourceManager.getColor(255, 0, 0));label_3.setFont(SWTResourceManager.getFont("黑体", 10, SWT.NONE));label_3.setText("您的输入有误！");label_3.setBounds(557, 340, 98, 27);System.out.println ("stop");//return;}}} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}}});button.setFont(SWTResourceManager.getFont("黑体", 12,SWT.NONE));button.setBounds(474, 293, 67, 27);//}@Overrideprotected void checkSubclass() {// Disable the check that prevents subclassing of SWT components }}2.成绩查询界面package editors;import java.sql.ResultSet;/*** 管理员对学生成绩管理**/public class成绩管理extends EditorPart {public成绩管理() {}private Text text;private Table table;┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊int start = 1;int pagesize = 10;int end =pagesize+start;public static final String ID = "editors.成绩管理"; //$NON-NLS-1$ /*** Create contents of the editor part* @param parent*/@Overridepublic void createPartControl(Composite parent) {System.currentTimeMillis();Composite container = new Composite(parent, SWT.NONE);container.setBackgroundImage(SWTResourceManager.getImage("G:\\\u 56FE\u7247\\ee.jpg"));/** 创建table***/table = new Table(container, SWT.FULL_SELECTION | SWT.BORDER);table.setLinesVisible(true);table.setHeaderVisible(true);table.setBounds(141, 69, 898, 195);final TableColumn newColumnTableColumn = new TableColumn(table, SWT.NONE);newColumnTableColumn.setWidth(100);newColumnTableColumn.setText("学号");final TableColumn newColumnTableColumn_1 = new TableColumn(table, SWT.NONE);newColumnTableColumn_1.setWidth(100);newColumnTableColumn_1.setText("姓名");final TableColumn newColumnTableColumn_2 = new TableColumn(table, SWT.NONE);newColumnTableColumn_2.setWidth(100);newColumnTableColumn_2.setText("课程名");final TableColumn newColumnTableColumn_3 = new TableColumn(table, SWT.NONE);newColumnTableColumn_3.setWidth(100);newColumnTableColumn_3.setText("课程类型");final TableColumn newColumnTableColumn_4 = new TableColumn(table, SWT.NONE);newColumnTableColumn_4.setWidth(100);newColumnTableColumn_4.setText("考核方式");final TableColumn newColumnTableColumn_5 = new TableColumn(table, SWT.NONE);newColumnTableColumn_5.setWidth(100);newColumnTableColumn_5.setText("考核成绩");final TableColumn newColumnTableColumn_6 = new TableColumn(table, SWT.NONE);newColumnTableColumn_6.setWidth(100);newColumnTableColumn_6.setText("学期");┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊final TableColumn newColumnTableColumn_7 = new TableColumn(table, SWT.NONE);newColumnTableColumn_7.setWidth(100);newColumnTableColumn_7.setText("学分");/*** 创建text*/text = new Text(container, SWT.BORDER);text.setBounds(229, 30, 80, 25);/*** 查询**/final Button button = new Button(container, SWT.NONE);button.addSelectionListener(new SelectionAdapter() {public void widgetSelected(final SelectionEvent e) {table.removeAll(); //清空tableJDBC g = new JDBC();String sql1 = "select top 10 * from 学生成绩表 where 姓名 like '%"+text.getText()+"%'";//查询前十条记录，模糊查询姓名ResultSet rs1 = g.query(sql1);try {while(rs1.next()){final TableItem newItemTableItem1 = newTableItem(table, SWT.BORDER);newItemTableItem1.setText(0,rs1.getString("学号") ); // 当前行的结果集放到0列newItemTableItem1.setText(1,rs1.getString("姓名") );newItemTableItem1.setText(2,rs1.getString("课程名") );newItemTableItem1.setText(3,rs1.getString("课程类型") );newItemTableItem1.setText(4,rs1.getString("考核方式") );newItemTableItem1.setText(5,rs1.getString("考核成绩") );newItemTableItem1.setText(6,rs1.getString("学期") );newItemTableItem1.setText(7,rs1.getString("学分") );}} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}}});button.setText("查询");button.setBounds(371, 28, 50, 27);/**┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊ * 上一页**/final Button button_1 = new Button(container, SWT.NONE);button_1.addSelectionListener(new SelectionAdapter() { public void widgetSelected(final SelectionEvent e) {if(start-pagesize>0){start = start-pagesize;end = end-pagesize;try {CreateTableData();//调用CreateTableData()方法} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}}}});button_1.setText("上一页");button_1.setBounds(229, 285, 50, 27);/*** 下一页**/final Button button_2 = new Button(container, SWT.NONE);button_2.addSelectionListener(new SelectionAdapter() { public void widgetSelected(final SelectionEvent e) {if(end-pagesize>0)start = start+pagesize;end = end+pagesize;try {CreateTableData();//调用CreateTableData()方法} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}}});button_2.setText("下一页");button_2.setBounds(318, 285, 50, 27);/*** 删除**/final Button button_3 = new Button(container, SWT.NONE);button_3.addSelectionListener(new SelectionAdapter() { public void widgetSelected(final SelectionEvent e) {int [] num = table.getSelectionIndices(); //获取当前行if(num.length>0){ //if语句TableItem[] items = table.getSelection();//JDBC h = new JDBC();for(int i=0;i<items.length;i++){ //for循环String id = items[i].getText(0); //获取i行0列h.update("delete from 学生成绩表 where 学号 ="+id+""); //删除语句}table.remove(num);┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊}else{System.out.println("请选择一行进行删除");}}});button_3.setText("删除");button_3.setBounds(420, 285, 50, 27);/*** 添加**/final Button button_4 = new Button(container, SWT.NONE);button_4.addSelectionListener(new SelectionAdapter() { public void widgetSelected(final SelectionEvent e) {try {Display display = Display.getDefault();//创建 display 对象.UpdateShell5 shell = new UpdateShell5(display, SWT.SHELL_TRIM);//shell程序的主窗体shell.open();yout();while (!shell.isDisposed()) {if (!display.readAndDispatch())display.sleep();}} catch (Exception e1) {e1.printStackTrace();}}});button_4.setText("添加");button_4.setBounds(520, 285, 50, 27);final Label label = new Label(container, SWT.NONE);label.setText("姓名：");label.setBounds(155, 33, 50, 25);/**** 修改**/final Button button_5 = new Button(container, SWT.NONE);button_5.addSelectionListener(new SelectionAdapter() { public void widgetSelected(final SelectionEvent e) {try {Display display = Display.getDefault();UpdateShell8 shell = new UpdateShell8(display, SWT.SHELL_TRIM);shell.open();yout();TableItem item = table.getSelection()[0];System.out.println(item+"FDGHJKL:DFGHJKLFGHJ");shell.setContent(item.getText(0),item.getText(1),item.getText(2) ,item.getText(3),item.getText(4),item.getText(5),item.getText(6),ite m.getText(7));while (!shell.isDisposed()) {┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊if (!display.readAndDispatch())display.sleep();}} catch (Exception e1) {e1.printStackTrace();}}});button_5.setText("修改");button_5.setBounds(622, 285, 50, 27);//}@Overridepublic void setFocus() {// Set the focus}@Overridepublic void doSave(IProgressMonitor monitor) {// Do the Save operation}@Overridepublic void doSaveAs() {// Do the Save As operation}@Overridepublic void init(IEditorSite site, IEditorInput input)throws PartInitException {setSite(site);setInput(input);// Initialize the editor part}@Overridepublic boolean isDirty() {return false;}@Overridepublic boolean isSaveAsAllowed() {return false;}/*** 翻页方法**/void CreateTableData() throws SQLException{table.removeAll();JDBC j = new JDBC();ResultSet rs = j.query("select * from (select row_number() over(order by 学号 asc) as k,* from 学生成绩表) as s where s.k >"+ start + " and s.k<=" + (start + pagesize) + "");while(rs.next()){┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊final TableItem newItemTableItem = new TableItem(table, SWT.BORDER);newItemTableItem.setText(0,rs.getString("学号") );newItemTableItem.setText(1,rs.getString("姓名") );newItemTableItem.setText(2,rs.getString("课程名") );newItemTableItem.setText(3,rs.getString("课程类型") );newItemTableItem.setText(4,rs.getString("考核方式") );newItemTableItem.setText(5,rs.getString("考核成绩") );newItemTableItem.setText(6,rs.getString("学期") );newItemTableItem.setText(7,rs.getString("学分") );}}}3.查找学生信息界面package editors;import java.sql.ResultSet;/*** 管理员对学生信息的管理**/public class学生信息extends EditorPart {public学生信息() {}private Text text_1;int start = 1;int pagesize = 1;int end =pagesize+start;private Table table;public static final String ID = "editors.学生信息"; //$NON-NLS-1$ /*** Create contents of the editor part* @param parent*/@Overridepublic void createPartControl(Composite parent) {System.currentTimeMillis();Composite container = new Composite(parent, SWT.NONE);container.setBackgroundImage(SWTResourceManager.getImage("G:\\\u 56FE\u7247\\ee.jpg"));/*** 创建table┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊ **/table = new Table(container, SWT.FULL_SELECTION | SWT.BORDER);table.setLinesVisible(true);table.setHeaderVisible(true);table.setBounds(51, 58, 1051, 219);final TableColumn newColumnTableColumn = new TableColumn(table, SWT.NONE);newColumnTableColumn.setWidth(57);newColumnTableColumn.setText("学号");final TableColumn newColumnTableColumn_1 = new TableColumn(table, SWT.NONE);newColumnTableColumn_1.setWidth(65);newColumnTableColumn_1.setText("姓名");final TableColumn newColumnTableColumn_2 = new TableColumn(table, SWT.NONE);newColumnTableColumn_2.setWidth(62);newColumnTableColumn_2.setText("性别");final TableColumn newColumnTableColumn_4 = new TableColumn(table, SWT.NONE);newColumnTableColumn_4.setWidth(67);newColumnTableColumn_4.setText("年龄");final TableColumn newColumnTableColumn_3 = new TableColumn(table, SWT.NONE);newColumnTableColumn_3.setWidth(68);newColumnTableColumn_3.setText("班级编号");final TableColumn newColumnTableColumn_5 = new TableColumn(table, SWT.NONE);newColumnTableColumn_5.setWidth(68);newColumnTableColumn_5.setText("出生年月");final TableColumn newColumnTableColumn_6 = new TableColumn(table, SWT.NONE);newColumnTableColumn_6.setWidth(65);newColumnTableColumn_6.setText("家庭住址");final TableColumn newColumnTableColumn_7 = new TableColumn(table, SWT.NONE);newColumnTableColumn_7.setWidth(65);newColumnTableColumn_7.setText("邮编");final TableColumn newColumnTableColumn_8 = new TableColumn(table, SWT.NONE);newColumnTableColumn_8.setWidth(70);newColumnTableColumn_8.setText("联系电话");final TableColumn newColumnTableColumn_9 = new TableColumn(table, SWT.NONE);newColumnTableColumn_9.setWidth(69);newColumnTableColumn_9.setText("政治面貌");final TableColumn newColumnTableColumn_10 = newTableColumn(table, SWT.NONE);newColumnTableColumn_10.setWidth(83);┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊newColumnTableColumn_10.setText("身份证号");final TableColumn newColumnTableColumn_11 = new TableColumn(table, SWT.NONE);newColumnTableColumn_11.setWidth(87);newColumnTableColumn_11.setText("准考证号");final TableColumn newColumnTableColumn_12 = new TableColumn(table, SWT.NONE);newColumnTableColumn_12.setWidth(75);newColumnTableColumn_12.setText("入学成绩");final TableColumn newColumnTableColumn_13 = new TableColumn(table, SWT.NONE);newColumnTableColumn_13.setWidth(71);newColumnTableColumn_13.setText("入学年份");final TableColumn newColumnTableColumn_14 = new TableColumn(table, SWT.NONE);newColumnTableColumn_14.setWidth(69);newColumnTableColumn_14.setText("注册日期");/*** 上一页**/final Button button = new Button(container, SWT.NONE);button.addSelectionListener(new SelectionAdapter() { public void widgetSelected(final SelectionEvent e) { if(start-pagesize>0){start = start-pagesize;end = end-pagesize;try {CreateTableData();//调用CreateTableData()} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}}}});button.setText("上一页");button.setBounds(120, 316, 50, 27);/*** 下一页**/final Button button_1 = new Button(container, SWT.NONE);button_1.addSelectionListener(new SelectionAdapter() { public void widgetSelected(final SelectionEvent e) { if(end-pagesize>0)start = start+pagesize;end = end+pagesize;try {CreateTableData();//调用CreateTableData()} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊}});button_1.setText("下一页");button_1.setBounds(209, 316, 50, 27);/*** 删除**/final Button button_2 = new Button(container, SWT.NONE);button_2.addSelectionListener(new SelectionAdapter() { public void widgetSelected(final SelectionEvent e) {int [] num = table.getSelectionIndices();//获取当前行if(num.length>0){//if语句TableItem[] items = table.getSelection();JDBC h = new JDBC();//JDBC实例化for(int i=0;i<items.length;i++){//for循环String id = items[i].getText(0);h.update("delete from 学生表 where 学号 ="+id+"");//删除语句}table.remove(num);}else{System.out.println("请选择一行进行删除");}}});button_2.setText("删除");button_2.setBounds(290, 316, 50, 27);/*** 添加**/final Button button_3 = new Button(container, SWT.NONE);button_3.addSelectionListener(new SelectionAdapter() { public void widgetSelected(final SelectionEvent e) {try {Display display = Display.getDefault();//创建 display 对象.UpdateShell shell = new UpdateShell(display,SWT.SHELL_TRIM);//shell程序的主窗体shell.open();yout();while (!shell.isDisposed()) {if (!display.readAndDispatch())display.sleep();}} catch (Exception e1) {e1.printStackTrace();}}});button_3.setText("添加");button_3.setBounds(374, 316, 50, 27);┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊text_1 = new Text(container, SWT.BORDER);text_1.setBounds(120, 27, 80, 25);final Button button_4 = new Button(container, SWT.NONE);button_4.addSelectionListener(new SelectionAdapter() { public void widgetSelected(final SelectionEvent e) {table.removeAll();JDBC g = new JDBC();String sql1 = "select top 1 * from 学生表 where 姓名like '%"+text_1.getText()+"%'";ResultSet rs1 = g.query(sql1);try {while(rs1.next()){final TableItem newItemTableItem1 = new TableItem(table, SWT.BORDER);newItemTableItem1.setText(0,rs1.getString("学号") );newItemTableItem1.setText(1,rs1.getString("姓名") );newItemTableItem1.setText(2,rs1.getString("性别") );newItemTableItem1.setText(3,rs1.getString("班级编号") );newItemTableItem1.setText(4,rs1.getString("年龄") );newItemTableItem1.setText(5,rs1.getString("出生年月") );newItemTableItem1.setText(6,rs1.getString("家庭住址") );newItemTableItem1.setText(7,rs1.getString("邮编") );newItemTableItem1.setText(8,rs1.getString("联系电话") );newItemTableItem1.setText(9,rs1.getString("政治面貌") );newItemTableItem1.setText(10,rs1.getString("身份证号") );newItemTableItem1.setText(11,rs1.getString("准考证号") );newItemTableItem1.setText(12,rs1.getString("入学成绩") );newItemTableItem1.setText(13,rs1.getString("入学年份") );newItemTableItem1.setText(14,rs1.getString("注册日期") );}} catch (SQLException e2) {// TODO Auto-generated catch blocke2.printStackTrace();}}});button_4.setText("查询");button_4.setBounds(290, 25, 50, 27);┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊final Label label = new Label(container, SWT.NONE);label.setText("姓名：");label.setBounds(51, 25, 42, 27);final Button button_5 = new Button(container, SWT.NONE);button_5.addSelectionListener(new SelectionAdapter() { public void widgetSelected(final SelectionEvent e) {try {Display display = Display.getDefault();UpdateShell13 shell = new UpdateShell13(display, SWT.SHELL_TRIM);shell.open();yout();TableItem item = table.getSelection()[0];shell.setContent(item.getText(0),item.getText(1),item.getText(2) ,item.getText(3),item.getText(4),item.getText(5),item.getText(6),ite m.getText(7),item.getText(8),item.getText(9),item.getText(10),item.g etText(11),item.getText(12),item.getText(13),item.getText(14));while (!shell.isDisposed()) {if (!display.readAndDispatch())display.sleep();}} catch (Exception e1) {e1.printStackTrace();}}});button_5.setText("修改");button_5.setBounds(462, 316, 50, 27);//}@Overridepublic void setFocus() {// Set the focus}@Overridepublic void doSave(IProgressMonitor monitor) {// Do the Save operation}@Overridepublic void doSaveAs() {// Do the Save As operation}@Overridepublic void init(IEditorSite site, IEditorInput input)throws PartInitException {setSite(site);setInput(input);// Initialize the editor part}@Override┊┊┊┊┊┊┊┊┊┊┊┊┊装┊┊┊┊┊订┊┊┊┊┊线┊┊┊┊┊┊┊┊┊┊┊┊┊public boolean isDirty() {return false;}@Overridepublic boolean isSaveAsAllowed() {return false;}/*** 翻页方法**/void CreateTableData() throws SQLException{table.removeAll();JDBC j = new JDBC();ResultSet rs = j.query("select * from (select row_number() over(order by 学号 asc) as k,* from 学生表) as s where s.k >"+ start + " and s.k<=" + (start + pagesize) + "");while(rs.next()){final TableItem newItemTableItem = new TableItem(table, SWT.BORDER);newItemTableItem.setText(0,rs.getString("学号") );newItemTableItem.setText(1,rs.getString("姓名") );newItemTableItem.setText(2,rs.getString("性别") );newItemTableItem.setText(3,rs.getString("班级编号") );newItemTableItem.setText(4,rs.getString("年龄") );newItemTableItem.setText(5,rs.getString("出生年月") );newItemTableItem.setText(6,rs.getString("家庭住址") );newItemTableItem.setText(7,rs.getString("邮编") );newItemTableItem.setText(8,rs.getString("联系电话") );newItemTableItem.setText(9,rs.getString("政治面貌") );newItemTableItem.setText(10,rs.getString("身份证号") );newItemTableItem.setText(11,rs.getString("准考证号") );newItemTableItem.setText(12,rs.getString("入学成绩") );newItemTableItem.setText(13,rs.getString("入学年份") );newItemTableItem.setText(14,rs.getString("注册日期") );}}}。