databaseconnection.java

来自「jsp 关于注册和登陆还有一些其他功能的jsp网叶」· Java 代码 · 共 28 行

package com.db;
import java.sql.*;

public class DatabaseConnection {
    private String driver="sun.jdbc.odbc.JdbcOdbcDriver";
    private String url="jdbc:odbc:city";
    private String user="admin";
    private String password="";
    private Connection conn;
    public DatabaseConnection() throws Exception{
    	Class.forName(driver);
    	conn = DriverManager.getConnection(url,user,password);
    }
    
    public ResultSet query(String sql,Object param[]) throws SQLException{
    	ResultSet rs=null;
    	PreparedStatement pstmt = conn.prepareStatement(sql);
    	 
    	for(int i=0;i<param.length;i++){
    		pstmt.setObject(i+1, param[i]);
    	}
    	rs = pstmt.executeQuery();
    	return rs;
    }
    
}