stu.java

这是一些精典的例程序,在这里和大家一起分离了.呵呵!

package stu;
import java.sql.*;
import java.net.*;
import java.io.*;
class show{
private	Connection con;
private	Statement st;
private	ResultSet r;
/***********************显示学生信息********************************/
	show(){
	 toyong();	 
	}
	void toyong(){
			System.out.println("basic information：");
		try{
		  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	      con=DriverManager.getConnection("jdbc:odbc:student.mdb");
	      st=con.createStatement();
		  r=st.executeQuery("SELECT * FROM stu1");
		}catch(Exception e2)
		    {
		 	System.out.println(e2.getMessage());
		 	}
	System.out.println(); 
	 System.out.print("    学号");
	 System.out.print("       姓名");
	 System.out.print("   性别");
	 System.out.print(" 年龄");
	 System.out.println(" java成绩");
	 System.out.println();
	 try{
	 	while(r.next())
	   {
	     String ID=r.getString("ID");
	     System.out.print(" "+ID+"   ");
	     String name=r.getString("name");
	     System.out.print(name+"   ");
	     String sex=r.getString("sex");
	     System.out.print(sex+"   ");
	     String age=r.getString("age");
	     System.out.print(age+"   ");
	     String javamark=r.getString("javamark");
	     System.out.println(" "+javamark+"   ");
	   	}
	   	   	con.close();	
	 	}catch(Exception e){} 	
		}
}
 /***********************************实现插入信息*********************************/
class insertinto{
private   String student_ID;
private   String student_NAME;
private   String student_SEX;
private   String student_AGE;
private   float student_JAVAMARK;
    
private String id,NAME,SEX,AGE;
private	float JAVAMARK;
private	Connection con;
private	Statement St;
private	ResultSet R;
	insertinto()
	{ 
	System.out.println("将新纪录插入到表中：");
    //toyong();
	}
	void toyong()
	{
		try{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		con=DriverManager.getConnection("jdbc:odbc:student.mdb");
	
	BufferedReader keyin=new BufferedReader(new InputStreamReader(System.in));
	String student_ID=keyin.readLine();
	String student_NAME=keyin.readLine();
	String student_SEX=keyin.readLine();
	String student_AGE=keyin.readLine();
	String JAVAMARK=keyin.readLine();	
	float student_JAVAMARK=Float.parseFloat(JAVAMARK);
	St=con.createStatement();
	String s="INSERT INTO stu1 VALUES('"+student_ID+"','"+student_NAME+"','"+student_SEX+"','"+student_AGE+"','"+student_JAVAMARK+"')";
	   try{ 
          int n=St.executeUpdate(s);
          if(n==1)System.out.println("插入成功！");
         }catch(Exception e)
         {
        System.out.println(e.getMessage()); 	
         	} 
         R=St.executeQuery("SELECT * FROM stu1");
         
         con.close(); 
		}catch(Exception e2)
		 
		 {
		 	System.out.println(e2.getMessage());
		 	}
         	
}
}
/*******************************实现信息筛选***********************************/
  class choose{
  	    private Connection con;
  	    private Statement st;
  	    private ResultSet r;
  	    private String aa;
  	    private float ff;
   choose(){

  	toyong();
  }
    void toyong(){
    	try{ 
	     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		 con=DriverManager.getConnection("jdbc:odbc:student.mdb");
	BufferedReader in=new BufferedReader(new InputStreamReader(System.in));
	     String ss=in.readLine();
	    float ff=Float.parseFloat(ss);
		  st=con.createStatement();
          r=st.executeQuery("SELECT * FROM stu1 WHERE javamark>"+ff);
	    while(r.next())
    {  
       String id,NAME,SEX,AGE;
       float JAVAMARK;
        id=r.getString("ID");
	   	NAME=r.getString("name");
	   	SEX=r.getString("sex");
	   	AGE=r.getString("age");
	   	JAVAMARK=r.getFloat("javamark");
 System.out.println("\t\t"+id+"\t"+NAME+"\t"+SEX+"\t"+AGE+"\t"+JAVAMARK+"\n");
	   	}
	   	con.close();
    }catch(Exception e1){
	   	System.out.println("Exception:"+e1.getMessage());
	                    }
	   }
} 
/*******************************实现删除操作*********************************/
class delete{	
        private Statement st;
		private Connection con;
		private ResultSet r;
		private String ss;
		private int aa;
  delete(){
  	System.out.println("你已经执行了此操作!");
  	toyong();
	 }
void toyong(){
		try{ 
	     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		 con=DriverManager.getConnection("jdbc:odbc:student.mdb");
		BufferedReader in=new BufferedReader(new InputStreamReader(System.in));
	     ss=in.readLine();
	     //aa=Integer.parseInt(ss);
		 st=con.createStatement();
		 int n=st.executeUpdate("DELETE FROM stu1 WHERE ID="+ss);
		 if(n==1)
		 System.out.println("删除成功！");
		 r=st.executeQuery("SELECT *FROM stu1");
while(r.next())
    {  
       String id,NAME,SEX,AGE;
       float JAVAMARK;
        id=r.getString("ID");
	   	NAME=r.getString("name");
	   	SEX=r.getString("sex");
	   	AGE=r.getString("age");
	   	JAVAMARK=r.getFloat("javamark");
 System.out.println("\t\t"+id+"\t"+NAME+"\t"+SEX+"\t"+AGE+"\t"+JAVAMARK+"\n");
	   	}
	   	con.close();
    }catch(Exception e1){
	   	System.out.println("Exception:"+e1.getMessage());
	                    }
	 }
	}