基于java语言的高校科研成果管理系统

package Labor; import java.awt.BorderLayout; import java.awt.Container; import java.awt.Dimension; import java.awt.Toolkit; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; import java.util.Vector; import javax.swing.JButton; import javax.swing.JComboBox; import javax.swing.JFrame; import javax.swing.JLabel; import javax.swing.JPanel; import javax.swing.JScrollBar; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.JTextField; import javax.swing.table.DefaultTableModel; public class Jiaoshishousuo1 extends JFrame implements ActionListener { JTable table1,table2,table3,table4,table5; JPanel panel1; Vector header, detail,header1, detail1,header2, detail2,header3, detail3,header4, detail4; static DefaultTableModel model,model1,model2,model3,model4; public Jiaoshishousuo1(){ Container c=new Container(); JLabel jl=new JLabel(); final JComboBox option; JButton jb=new JButton(); this.setLayout(null); jl=new JLabel("类别："); add(jl); jl.setBounds(0, 0, 50, 20); String[] a=new String[]{"论文","著作","立项","专利","获奖成果"}; option =new JComboBox(a); add(option); option.setBounds(50,0,100,20); jb=new JButton("查询"); add(jb); jb.setBounds(170,0,60,20); this.setVisible(true); pack(); Toolkit kit=Toolkit.getDefaultToolkit(); Dimension screen=kit.getScreenSize(); int x=screen.width; int y=screen.height; setSize(600,500); int xCenter=(x-600)/2; int yCenter=(y-500)/2; setLocation(xCenter,yCenter); setResizable(false); jb.addActionListener(new ActionListener(){ @SuppressWarnings({ "unchecked", "rawtypes" }) @Override public void actionPerformed(ActionEvent e) { Vector colum_1 = new Vector(); Vector rows_1 = new Vector(); Vector colum_2 = new Vector(); Vector rows_2 = new Vector(); String sel = (String) option.getSelectedItem(); String url ="jdbc:mysql://localhost:3306/design"; String user="root"; String password="qwe123456"; //连接数据库,执行相关操作 try { Class.forName("com.mysql.jdbc.Driver"); Connection conn=DriverManager.getConnection(url,user,password); final Statement stat=conn.createStatement(); //分为“读者姓名"和"读者编号"两部分操作 //读者姓名部分 if(sel.equals("论文")){ detail=new Vector(); header=new Vector(); header.add("论文题目"); header.add("作者"); header.add("发表时间"); header.add("期刊杂志名称"); header.add("版次"); header.add("类别"); header.add("工号"); header.add("姓名"); model=new DefaultTableModel(detail,header); table1=new JTable(model); JScrollPane src=new JScrollPane(table1); add(src); src.setBounds(0,50,600,60); String str[]=new String[8]; ResultSet rs=DBHelper.query("select * from paper"); try{ while(rs.next()){ str[0]=rs.getString(1); str[1]=rs.getString(2); str[2]=rs.getString(3); str[3]=rs.getString(4); str[4]=rs.getString(5); str[5]=rs.getString(6); str[6]=rs.getString(7); str[7]=rs.getString(8); model.addRow(str); } }catch(SQLException e1){ e1.printStackTrace(); }} else if(sel.equals("著作")){ detail1=new Vector(); header1=new Vector(); header1.add("书名"); header1.add("作者"); header1.add("发表时间"); header1.add("出版社名称"); header1.add("版次"); header1.add("获奖情况"); header1.add("工号"); header1.add("姓名"); model1=new DefaultTableModel(detail1,header1); table2=new JTable(model1); JScrollPane src1=new JScrollPane(table2); add(src1); src1.setBounds(0,50,600,60); String str1[]=new String[8]; ResultSet rs1=DBHelper.query("select * from book"); try{ while(rs1.next()){ str1[0]=rs1.getString(1); str1[1]=rs1.getString(2); str1[2]=rs1.getString(3); str1[3]=rs1.getString(4); str1[4]=rs1.getString(5); str1[5]=rs1.getString(6); str1[6]=rs1.getString(7); str1[7]=rs1.getString(8); model1.addRow(str1); } }catch(SQLException e1){ e1.printStackTrace(); } }else if(sel.equals("立项")){ detail2=new Vector(); header2=new Vector(); header2.add("项目名称"); header2.add("主持者"); header2.add("参与者"); header2.add("立项时间"); header2.add("项目类别"); header2.add("项目级别"); header2.add("工号"); header2.add("姓名"); model2=new DefaultTableModel(detail2,header2); table3=new JTable(model2); JScrollPane src2=new JScrollPane(table3); add(src2); src2.setBounds(0,50,600,60); String str2[]=new String[8]; ResultSet rs2=DBHelper.query("select * from project"); try{ while(rs2.next()){ str2[0]=rs2.getString(1); str2[1]=rs2.getString(2); str2[2]=rs2.getString(3); str2[3]=rs2.getString(4); str2[4]=rs2.getString(5); str2[5]=rs2.getString(6); str2[6]=rs2.getString(7); str2[7]=rs2.getString(8); model2.addRow(str2); } }catch(SQLException e1){ e1.printStackTrace(); } }else if(sel.equals("专利")){ detail3=new Vector(); header3=new Vector(); header3.add("专利名称"); header3.add("主持者"); header3.add("参与者"); header3.add("立项时间"); header3.add("专利类别"); header3.add("专利级别"); header3.add("工号"); header3.add("姓名"); model3=new DefaultTableModel(detail3,header3); table4=new JTable(model3); JScrollPane src3=new JScrollPane(table4); add(src3); src3.setBounds(0,50,600,60); String str3[]=new String[8]; ResultSet rs3=DBHelper.query("select * from patent"); try{ while(rs3.next()){ str3[0]=rs3.getString(1); str3[1]=rs3.getString(2); str3[2]=rs3.getString(3); str3[3]=rs3.getString(4); str3[4]=rs3.getString(5); str3[5]=rs3.getString(6); str3[6]=rs3.getString(7); model3.addRow(str3); } }catch(SQLException e1){ e1.printStackTrace(); } }else if(sel.equals("获奖成果")){ detail4=new Vector(); header4=new Vector(); header4.add("获奖名称"); header4.add("奖励级别"); header4.add("获奖时间"); header4.add("工号"); header4.add("姓名"); model4=new DefaultTableModel(detail4,header4); table5=new JTable(model4); JScrollPane src4=new JScrollPane(table5); add(s