package ms; //数据库的连接 import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class DataBaseConnection { Connection con = null; Statement sql = null; ResultSet rs = null; public DataBaseConnection() { // shujuku try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); // 加载驱动 } catch (ClassNotFoundException e) { System.out.println(e); } try { con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=大学城校园美食联盟", "sa", "lch"); // 连接数据库 } catch (SQLException e) { System.out.println(e); } } // 查询 public ResultSet executeQuery(String sql_s) { try { sql = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); rs = sql.executeQuery(sql_s); } catch (SQLException e) { System.out.println(e); } return rs; } // 关闭数据库 public void close() { if (rs != null) { try { rs.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } if (con != null) { try { con.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } }