dbconn.java

图书馆管理系统,从我们导师的实验室(国家重点实验室)带出来的,不过是我们自己开发的,已经提交,没有问题!站长采纳,可别说是偶传的噢!

package booksys;

import java.sql.*;
import java.util.Properties;


public class dbconn{
	public static Connection conn;
	public static ResultSet rt;
	
	public static void conn() throws Exception{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Properties p = new Properties();
		//p.put("databasename","tsgl");
		p.put("user","sa");
		p.put("password","");
		conn = DriverManager.getConnection("jdbc:odbc:tsgl",p);
		
		}
		
	public static ResultSet dbquery(String sql) throws Exception{
		Statement st = conn.createStatement();
		rt = st.executeQuery(sql);
		return rt;
		}
		
	public static int dbinsert(String sql) throws Exception{
		Statement st = conn.createStatement();
		int s=st.executeUpdate(sql);
		return s;
		}
		
	public static int dbupdate(String sql) throws Exception{
		Statement st = conn.createStatement();
		int s=st.executeUpdate(sql);
		return s;
		}
	
	public static void dbclose() throws Exception{
		if(rt!=null){
			 rt.close();
			 rt=null;
		}
		
		if(conn!=null) {
			conn.close();
			conn=null;
			}
		}
	}