studentscore.java

一个 用java实现的 生信息管理系统,其中 数据库是用Oracle

//查询学生成绩界面

package txl.student.panel ;

import java.awt.* ;
import java.awt.event.* ;
import javax.swing.* ;
import java.sql.* ;
import txl.student.user.Users ;
import txl.student.panel.* ;

public class StudentScore extends JPanel implements ActionListener
 {
	 private JPanel pTop = null ;
	 private JTextField text = null ;
	 private JLabel lab = null ;
	 private JButton button = null ;
	 private ATextArea area = null ;

	 public JTextField getText()
	  {
		  return text ;
	  }

	 public StudentScore()
	  {
		 lab = new JLabel("学号：") ;
		 text = new JTextField(12) ;
		 button = new JButton("查询") ;
		 button.addActionListener(this) ;
         pTop = new JPanel() ;
		 pTop.add(lab) ;
		 pTop.add(text) ;
		 pTop.add(button) ;

		 area = new ATextArea() ;
		 this.setLayout(new BorderLayout()) ;
		 this.add(pTop, BorderLayout.NORTH) ;
		 this.add(area, BorderLayout.CENTER) ;

		 validate() ;
	  }//public StudentInfo
	 public void actionPerformed(ActionEvent e)
	  {
		  if(e.getSource()==button)
		   {
			  area.getTextArea().setText(null) ;
			  String uname = text.getText().trim() ;
			  //System.out.println("**"+uname) ;
			  //text.setText(null) ;
			  /*
			  if(uname==null||uname.length()!=0)
			   {
				   text.setText(null) ;
			   }
			  */
			  if(uname.length()!=0)
			   {
				  System.out.println("** uname："+uname) ;
				  System.out.println("** 2"+uname) ;
				  Connection conn = null ;
				  Statement stmt = null ;
				  ResultSet rset = null ;
				  try
				   {
					 Class.forName("oracle.jdbc.driver.OracleDriver");
					 conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:TXL2008","scott","txl2008");
					 stmt = conn.createStatement( );
					 String sql = "select * from student_course where student_code='"+uname+"'" ;
					 rset = stmt.executeQuery(sql);
					 //rset.last() ;
					 int number = rset.getRow() ;
					 System.out.println("行数："+number) ;
					 /*
					 if(number<1) //没有该学生
					  {
						  area.getTextArea().setText("\n\n\t学号为"+uname+"的学生不存在") ;
					  }
					 else
					 */
					  //{
						 area.getTextArea().append("学号\t姓名\t课程\t成绩\t学分\t备注\n") ;
						 while(rset.next())
						  {
							  //System.out.println("查找成功！！") ;
							  area.getTextArea().append(rset.getString(1)+"\t") ;
							  area.getTextArea().append(rset.getString(2)+"\t") ;
							  area.getTextArea().append(rset.getString(3)+"\t") ;
							  area.getTextArea().append(rset.getString(4)+"\t") ;
							  area.getTextArea().append(rset.getString(5)+"\t") ;
                              area.getTextArea().append(rset.getString(6)+"\t") ;
							  area.getTextArea().append("\n") ;
						  }
					  //}
				     rset.close() ;
					 stmt.close() ;
					 conn.close() ;

				   }
				  catch(Exception ex)
				   { System.out.println(ex) ; }

			   }
			 else
			  {
				  text.setText("请输入要查询的学生的学号！") ;
			  }
		   }
	  } //void actionPerformed
 }