dbm.java

管理系统实现的源代码,

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package 学生成绩管理系统;

import java.sql.*;//引入SQL包
public class DBM
{
 ResultSet rs; //定义返回结果值
 ResultSet rs1;
 String strurl = "jdbc:odbc:student";//创建指定数据库的URL
 String strdriver = "sun.jdbc.odbc.JdbcOdbcDriver";//创建驱动程序
 public Connection con=null;
 public Statement st=null;
 //查询方法,返回查询结果集
 public ResultSet getResult(String sql)
 {
  try
 {
  Class.forName(strdriver);
  con = DriverManager.getConnection(strurl);
  st = con.createStatement();
  rs = st.executeQuery(sql);
  return rs;
 }//end try
   catch(Exception e)
   {
    System.out.println("getResult  "+e.toString());
    return null;
    }//end catch
  }//end getResult
 //执行更新、删除语句方法
 public void executeSql(String sql)
 {
  try{
   Class.forName(strdriver);
   con = DriverManager.getConnection(strurl);
   st = con.createStatement();
   st.executeUpdate(sql);
   con.commit();
  }//end try
  catch(Exception e)
   {
    System.out.println("getResult  " + e.toString());
    
    }//end catch 
  }//end executeSql
 public void close() throws SQLException{
   if(con!=null) con.close();
 }//end close
 }//end DBM