student_look1.java

一个关于图书馆管理系统的课程设计

//学生查询自己的信息
import javax.swing.*;
import javax.swing.event.*;
import java.awt.*;
import java.awt.event.*;
import java.io.*;
import java.sql.*;
public class student_look1 extends JFrame implements ActionListener
{
	JTextField sno;
	JTextArea message;
	Label sno1;
	Label message1;
	JButton a_enter1;
	JButton a_enter2;
	JButton a_enter3;
	JButton b1;
	public student_look1()
	{
    	super("学生查询自己的信息");	
    	sno=new JTextField(20);
		message=new JTextArea(10,50);
		sno1=new Label("    学号    ");
		message1=new Label(" 学生信息 ");
	 	a_enter2=new JButton("查询");
	 	b1=new JButton("返回");
		a_enter2.addActionListener(this);
		b1.addActionListener(this);
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); //设定关闭窗体时退出程
		JPanel pane=new JPanel();//定义主面板
		pane.setLayout(new FlowLayout());
		pane.add(sno1); 
		pane.add(sno); 
		pane.add(message1); 
		pane.add(message);
		pane.add(a_enter2);
		pane.add(b1);
		this.add(pane);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==a_enter2)
		{
			 String t=sno.getText();
			 String url1="jdbc:odbc:agang";
			 String sql="select * FROM student where student.sno='"+t+"'";
			try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  //驱动程序名称_JDBC/ODBC桥接驱动程序
			}catch(java.lang.ClassNotFoundException e1){}
			try{
					Connection con=DriverManager.getConnection(url1,"",null);//建立连接
					Statement stmt=con.createStatement();
				  	ResultSet rs=stmt.executeQuery(sql);  
				  	while(rs.next())
					  	{ 
						  String s1=rs.getString("sno");
						  String s2=rs.getString("sname");
						  String s3=rs.getString("ssystem");
						  String s4=rs.getString("sage");
						  String s5=rs.getString("sclass");
						  System.out.println(s1);
						  message.setText("     "+"学号:"+s1+" 姓名:"+s2+" 所在系:"+s3+" 出生年月:"+s4+" 班级:"+s5);
						  /*if(t.trim().equals(s1))
						  {
						  	message.setText("学号:"+s1+"姓名"+s2+"所在系"+s3+"出生年月"+s4+"班级"+s5);
						  	System.out.println();
						  }	*/	  	  
			  		} stmt.close();
			    	con.close();
				}catch(SQLException e2){}
				
				String rl1="jdbc:odbc:agang";
				String ql="select * FROM grade where grade.sno='"+t+"'";
				try{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  //驱动程序名称_JDBC/ODBC桥接驱动程序
				}catch(java.lang.ClassNotFoundException e2){}
				try{
					Connection con=DriverManager.getConnection(rl1,"",null);//建立连接
					Statement tmt=con.createStatement();
				  	ResultSet rs1=tmt.executeQuery(ql);  
				  	while(rs1.next())
					  	{ 
						  String s7=rs1.getString("gcourse");
						  String s8=rs1.getString("ggrade");
						  message.append("课程:"+s7+" 成绩:"+s8+"\n");
						  /*if(t.trim().equals(s1))
						  {
						  	message.setText("学号:"+s1+"姓名"+s2+"所在系"+s3+"出生年月"+s4+"班级"+s5);
						  	System.out.println();
						  }	*/	  	  
			  		} tmt.close();
			    	con.close();
				}catch(SQLException e2){}
				  
				  
		}
		else{
			dispose();
			student_look x1=new student_look();
			x1.setVisible(true);
			x1.setLocation(300,300);
			x1.setSize(600,600);
		}
	}
	public static void main(String args[])
	{
		student_look1 x=new student_look1();
		x.setVisible(true);
		x.setLocation(300,300);
		x.setSize(350,500);
	}
}