studentsql.java

一个JAVA的学生管理系统,用的是GUI的图形用户界面.

import java.sql.*;




//////////////开始的入口处在pp2






class StudentSql{
	Connection con=null;
	Statement st=null;
	ResultSet rs=null;
	String selname,selnumber,selgrade,selclanguage,selenglish,selmaths,selmore;
	public static void main(String args[])throws Exception{
		StudentSql a=new StudentSql();
		a.Update("number","05010056","sister");
	}
	void Connect()throws Exception{
		String JDriver="sun.jdbc.odbc.JdbcOdbcDriver";
		String conurl="jdbc:odbc:Studentinfo";
		Class.forName(JDriver);
		con=DriverManager.getConnection(conurl);
		st=con.createStatement();
	}
	void Close()throws Exception{
		st.close();
		con.close();		
	}
	void Success(){
		System.out.println("success!");
	}
	void Nosuccess(){
		System.out.println("no success!");
	}
	void P()throws Exception{
		System.out.println(selname);
		System.out.println(selnumber);
	}
	void Print()throws Exception{
		while(rs.next()){
			System.out.println(rs.getString("name")+"\n");
			System.out.println(rs.getString("number")+"\n");
			System.out.println(rs.getString("grade")+"\n");
			System.out.println(rs.getString("clanguage")+"\n");
			System.out.println(rs.getString("english")+"\n");
			System.out.println(rs.getString("maths")+"\n");
			System.out.println(rs.getString("more")+"\n");
		}
	}
	void RsNext()throws Exception{
		rs.next();
		selname=rs.getString("name");
		selnumber=rs.getString("number");
		selgrade=rs.getString("grade");
		selclanguage=rs.getString("clanguage");
		selenglish=rs.getString("english");
		selmaths=rs.getString("maths");
		selmore=rs.getString("more");

	}
	
	void Fuzhi1(String studentname)throws Exception{
		this.Connect();
		String selectquery="select * from Studentinfo where name=";
		selectquery+=("'"+studentname+"'");
		try{
			rs=st.executeQuery(selectquery);
				this.RsNext();
			this.Success();
		}catch(Exception sen){
			this.Nosuccess();
		}
		this.Close();
		//System.out.println(selmore);
	}
	void Fuzhi2(String studentnumber)throws Exception{
		this.Connect();
		String selectquery="select * from Studentinfo where number=";
		selectquery+=("'"+studentnumber+"'");
		try{
			rs=st.executeQuery(selectquery);
				this.RsNext();
			this.Success();
		}catch(Exception sen){
			this.Nosuccess();
		}
		this.Close();
	}
	
	void Update(String fieldname,String newvalue,String updatename)throws Exception{
		this.Connect();
		String updatequery="update Studentinfo set ";
		updatequery+=(fieldname+"=");
		updatequery+=("'"+newvalue+"' ");
		updatequery+="where name=";
		updatequery+=("'"+updatename+"'");
		try{
			st.executeUpdate(updatequery);
			this.Success();
		}catch(Exception upe){
			this.Nosuccess();
		}
		this.Close();
	}
	void Delete(String deletename)throws Exception{
		this.Connect();
		String deletequery="delete from Studentinfo where name=";
		deletequery+=("'"+deletename+"'");
		try{
			st.executeUpdate(deletequery);
			this.Success();
			
		}catch(Exception del){
			this.Nosuccess();
		}
		this.Close();
	}
	void Insert(String studentname,String studentnumber,String studentgrade,String clanguage,String english,String maths,String more)throws Exception{
		this.Connect();
		String insertquery="insert into Studentinfo values(";
		insertquery+=("'"+studentname+"',");
		insertquery+=("'"+studentnumber+"',");
		insertquery+=("'"+studentgrade+"',");
		insertquery+=("'"+clanguage+"',");
		insertquery+=("'"+english+"',");
		insertquery+=("'"+maths+"',");
		insertquery+=("'"+more+"')");
		try{
			st.executeUpdate(insertquery);
			this.Success();
		}catch(Exception ine){
			this.Nosuccess();
		}
		this.Close();
	}
}