aaa.rar_学生成绩管理系统_学生成绩管理系统 java_成绩管理系统_成绩管理系统 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("关闭连接出错"); } } }