58,454
社区成员
发帖
与我相关
我的任务
分享
package datebase;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBC {
Connection conn = null;
Statement st = null;
ResultSet rs = null;
PreparedStatement ps;
public JDBC() {
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");// 2005
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
conn = DriverManager.getConnection(
"jdbc:sqlserver://localhost:1433;DatabaseName=db_dqcc",
"sa", "sasa");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
// 创建语句对象
st = conn.createStatement();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public ResultSet query(String sql) {
try {
rs = st.executeQuery(sql);
} catch (SQLException e) {
System.out.println("查询操作异常:" + e);
e.printStackTrace();
}
return rs;
}
public int update(String sql) {
int i = -1;
try {
i = st.executeUpdate(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return i;
}
public int executeUpdate(String sql)// 更新调用类
{
int count = 0;
try {
st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
count = st.executeUpdate(sql);
} catch (Exception ex) {
ex.printStackTrace();
}
return count;
}
public PreparedStatement preparedStatement(String sql) {
try {
ps = conn.prepareStatement(sql, ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
} catch (Exception ex) {
ex.printStackTrace();
}
return ps;
}
public void close() {
try {
st.close();
} catch (SQLException e) {
System.out.println("关闭stmt异常:" + e);
e.printStackTrace();
}
try {
conn.close();
} catch (SQLException e) {
System.out.println("关闭conn异常:" + e);
e.printStackTrace();
}
}
}