20e1a7244851001d1bf0e3fd64315979

来自「酒店预订系统具有登录」· 代码 · 共 44 行

package hote;
import java.sql.*;
import java.util.*;
import java.io.*;
public class connsql {
	String DBDriver = "sun.jdbc.odbc.JdbcOdbcDriver"; //指定驱动程序
	String ConnStr = "jdbc:odbc:hotemanaga";//指定数据库
	Connection conn = null; //指定链接
	ResultSet rs = null; //返回结果集
	Statement stmt = null;//发送数据库字符串
    public connsql() throws Exception
    {
    	try { 
    		Class.forName(DBDriver); //加载数据库驱动程序
    		conn = DriverManager.getConnection(ConnStr); //与DBMS建立连接 
    		stmt = conn.createStatement(); 
    		} 
    		catch(java.lang.ClassNotFoundException e) { 
    		System.err.println("DBconn (): " + e.getMessage()); 
    		} 

    }
    public ResultSet  executeQuery(String sql)throws Exception
    {
    	
    	ResultSet RS = stmt.executeQuery(sql); 
         return RS;
    	
    }
    
    public int executeUpdate(String sql) { 
		int i = 0;
		try {			
			stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			i = stmt.executeUpdate(sql);
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return i;

	}
}