jdbc
来源:互联网 发布:中万网络工资怎么样 编辑:程序博客网 时间:2024/05/21 11:25
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;
}
}
- jdbc
- JDBC
- jdbc
- JDBC
- jdbc
- JDBC
- JDBC
- JDBC
- JDBC
- JDBC
- JDBC
- JDBC
- JDBC
- JDBC
- jdbc
- JDBC
- JDBC
- jdbc
- Linux 串口读写(一)
- myweb0.2版本(更新)
- Linux 的 initrd (linuxrc,init)
- android
- vmlinuz
- jdbc
- 几个问题。
- VMware安装GHOST版XP教程
- select使用示例
- thrift, Protocol Buffers and MsgPack 的序列化对比
- presentModalViewControllerAnimated 和 dismissModalViewControllerAnimated
- 71道经典Android面试题和答案
- jquery 鼠标点击挪动div实现
- 关于递归原理