import java.sql.*;
public class DataBaseConnection {
static{
//2005
//String DBDRIVER="com.microsoft.jdbc.sqlserver.SQLServerDriver";//2000
}
public static Connection getConn(){
String DBDRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
String DBURL="jdbc:sqlserver://localhost:1433;DatabaseName=cwgl";
Connection conn=null;
try {
Class.forName(DBDRIVER);
conn=DriverManager.getConnection(DBURL,"sa","1");
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
public static void closeConn(Connection conn){
try {
conn.close();
conn=null;
} catch (SQLException e) {
e.printStackTrace();
}
}
public static Statement getStmt(Connection conn){
Statement stmt=null;
try {
stmt=conn.createStatement();
} catch (SQLException e) {
e.printStackTrace();
}
return stmt;
}
public static void closeStmt(Statement stmt){
try {
stmt.close();
stmt=null;
} catch (SQLException e) {
e.printStackTrace();
}
}
public static PreparedStatement getpStmt(Connection conn,String sql){
PreparedStatement pStmt=null;
try {
pStmt=conn.prepareStatement(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return pStmt;
}
public static void closePstmt(Statement pstmt){
try {
pstmt.close();
pstmt=null;
} catch (SQLException e) {
e.printStackTrace();
}
}
public static ResultSet getRs(Statement stmt,String sql){
ResultSet rs=null;
try {
rs=stmt.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}
public static void closeRs(ResultSet rs){
try {
rs.close();
rs=null;
} catch (SQLException e) {
e.printStackTrace();
}
}
}
2021-06-04 21:00:41
122KB
1
一、数据库设计过程数据库技术是信息资源管理最有效的手段。数据库设计是指对于一个给定的应用环境，构造最优的数据库模式，建立数据库及其应用系统，有效存储数据，满足用户信息要求和处理要求。
2021-06-04 11:36:52
43KB
1