conn.java

毕业设计JSP公交车查询系统

package bus.db;

import java.sql.*;

public class Conn {
    private String drives = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
    private String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=bus";
    private String user="sa";
    private String pass="123123";
    Connection con;
    public Conn() {
        try {
            Class.forName(drives);
            con = DriverManager.getConnection(url,user,pass);
        } catch (Exception e) {
            System.err.println(e);
        }
    }

    /**
     * 对数据库进行查询
     * @param sql String
     * @return ResultSet
     */
    public ResultSet executeQuery(String sql) {
        ResultSet rs = null;
        try {
            Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
            rs = stmt.executeQuery(sql);
        } catch (SQLException e) {
            System.err.println(e);
        }
        return rs;
    }

    /**
     * 对数据库进行增删改
     * @param sql String
     */
    public void executeUpdata(String sql) {
        try {
            Statement stmt = con.createStatement();
            stmt.executeUpdate(sql);
        } catch (SQLException e) {
            System.err.println(e);
        }
    }
  
    public PreparedStatement getPre(String sql) throws SQLException 
    {
    	return con.prepareStatement(sql);
    }
    

    /**
     * 关闭连接
     */
    public void closeConn() {
        try {
            if (con != null) {
                con.close();
            }
        } catch (SQLException e) {
            System.err.println(e);
        }
    }

    
}