access.java

关于学生成绩管理系统的,是比较好的.估计适合比较多的学校的

import java.sql.*;

class access{
	
	private Statement stmt;
	private ResultSet rs;
	private Connection conn;
	
  public access(){

    	String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=student.mdb";
														
		Connection conn = null;
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			conn = DriverManager.getConnection(strurl, null, null);
			stmt = conn.createStatement();
		} 
		catch (Exception e) {
			System.out.println("not conect");
			//e.printStackTrace();
		}
	}
	
	
	public void insert(String data, String data2,String data3,String table){
		try{
			String sql="insert into "+table+" values('"+data+"','"+data2+"','"
			+data3+"')";
		//	System.out.print(sql);
			this.stmt.execute(sql);
			//stmt.close();
			
		}		
		catch (Exception e) {
			//e.printStackTrace();
			System.out.println("数据库操作有误！！");
		}
	}
	
	public void insert(String data,int data2,String data3,String table){
		try{
			String sql="insert into "+table+" values('"+data+"','"+data2+"','"
			+data3+"')";
		//	System.out.print(sql);
			this.stmt.execute(sql);
		}		
		catch (Exception e) {
			e.printStackTrace();
			System.out.println("数据库操作有误！！");
		}
	}
	
	
	public void insert(String data, String data2,String data3,String data4,
	String table){
		try{
			String sql="insert into "+table+" values('"+data+"','"+data2+"','"
			+data3+"','"+data4+"')";
		//	System.out.print(sql);
			this.stmt.execute(sql);			
		}		
		catch (Exception e) {
			//e.printStackTrace();
			System.out.println("数据库操作有误！！");
		}
	}
	
	public void insert(String data, String data2,String table){
		try{
			String sql="insert into "+table+" values('"+data+"','"+data2+"','')";
		//	System.out.print(sql);
			this.stmt.execute(sql);
		}		
		catch (Exception e) {
			//e.printStackTrace();
			System.out.println("数据库操作有误！！");
		}
	}
	
	public String requir(String lesson,int score,int score2,String classes){
		String count1=null;
		try{
			ResultSet rs =null;
			String sql="select count(*) as a from score,student where lessonname='"
			+lesson+"' and lscore>="+score+"and lscore<="+score2
			+" and student.stname=score.stname and student.stclass='"+classes+"'";
		//	System.out.println(sql);
			stmt.execute(sql);
			rs = stmt.executeQuery(sql);
			
			while (rs.next()) {
				//System.out.print(rs.getString("a"));
				//System.out.print(rs.getString("stname"));
				//System.out.println();
				count1=rs.getString("a");
				}
		}
		catch (Exception e) {
			//e.printStackTrace();
			System.out.println("数据库操作有误！！");
		}
		return count1;
	}
	
	public String requir(String lesson,String[] result){				//查课程
		String count1=null;
		try{
			ResultSet rs =null;
			String sql="select * from lesson where lessonname='"+lesson+"'";
		//	System.out.println(sql);
			stmt.execute(sql);
			rs = stmt.executeQuery(sql);
			
			while (rs.next()) {
				//System.out.print(rs.getString("a"));
				//System.out.print(rs.getString("stname"));
				//System.out.println();
				result[0]=rs.getString("lessonname");
				result[1]=rs.getString("numofstu");
				result[2]=rs.getString("xuefen");
				}
		}
		catch (Exception e) {
			//e.printStackTrace();
			System.out.println("数据库操作有误！！");
		}
		return count1;
	}
	
	public int requir(String data,String table,String[] result){
		int i=0;
		try{
			ResultSet rs =null;
			String sql="select "+data+" from "+table;
			//System.out.println(sql);
			stmt.execute(sql);
			rs = stmt.executeQuery(sql);
			while (rs.next()) {
				//System.out.print(rs.getString("a"));
				//System.out.print(rs.getString("stname"));
				//System.out.println();
				result[i]=rs.getString(data);
				i++;
				}
		}
		catch (Exception e) {
			//e.printStackTrace();
			System.out.println("数据库操作有误！！");
		}
		return i;
	}
	
	public int rr(String lesson,String classes,String[] result){
		int i=0;
		try{
			ResultSet rs =null;
			String sql="select score.stname,lscore from score,student where lessonname='"
			+lesson+"' and student.stname=score.stname and stclass='"+classes+
			"' order by lscore desc";
			//System.out.println(sql);
			stmt.execute(sql);
			rs = stmt.executeQuery(sql);
			while (rs.next()) {
				//System.out.print(rs.getString("a"));
				//System.out.print(rs.getString("stname"));
				//System.out.println();
				result[i]="                                  "
				+rs.getString("stname")+"         "+rs.getInt("lscore");
				i++;
				}
		}
		catch (Exception e) {
			e.printStackTrace();
			System.out.println("数据库操作有误！！");
		}
		return i;
	}
	
	
	public void close(){
		try{
			stmt.close();
			stmt=null;
			conn.close();
			
			conn=null;
		}
		catch(Exception e){
			//e.printStackTrace();
			//System.out.println("关闭连接出错");
		}
	}
}