import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DaoSupport {
private Connection con = null;
private Statement stmt = null;
private ResultSet rs = null;
private String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private String url = "jdbc:sqlserver://localhost:1433;databaseName=abc";
private String user = "sa";
private String pass = "pass";
/**
* 启动数据库连接
* @throws Exception
*/
public void beginConnection() throws Exception {
Class.forName(driver);
con = DriverManager.getConnection(url, user, pass);
}
/**
* 释放数据库连接
*/
public void endConnection() {
try{
if(rs!=null){
rs.close();
}
if(stmt!=null){
stmt.close();
}
if(con!=null){
con.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* 执行 insert update delete操作
* @param sql
* @return
* @throws SQLException
*/
public int update(String sql) throws SQLException{
stmt=con.createStatement();
int r=stmt.executeUpdate(sql);
return r;
}
/**
* 执行select 并返回结果集
* @param sql
* @return
* @throws SQLException
*/
public ResultSet query(String sql) throws SQLException{
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
return rs;
}
}
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DaoSupport {
private Connection con = null;
private Statement stmt = null;
private ResultSet rs = null;
private String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private String url = "jdbc:sqlserver://localhost:1433;databaseName=abc";
private String user = "sa";
private String pass = "pass";
/**
* 启动数据库连接
* @throws Exception
*/
public void beginConnection() throws Exception {
Class.forName(driver);
con = DriverManager.getConnection(url, user, pass);
}
/**
* 释放数据库连接
*/
public void endConnection() {
try{
if(rs!=null){
rs.close();
}
if(stmt!=null){
stmt.close();
}
if(con!=null){
con.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* 执行 insert update delete操作
* @param sql
* @return
* @throws SQLException
*/
public int update(String sql) throws SQLException{
stmt=con.createStatement();
int r=stmt.executeUpdate(sql);
return r;
}
/**
* 执行select 并返回结果集
* @param sql
* @return
* @throws SQLException
*/
public ResultSet query(String sql) throws SQLException{
stmt=con.createStatement();
rs=stmt.executeQuery(sql);
return rs;
}
}