package JDBCConn;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JDBCconn {
static ReaderProperties readpro = new ReaderProperties();
private Connection conn = null;
private PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = null;
private String datatype = readpro.reader().getDbtype();
private String url = readpro.reader().getUrl();
private String username = readpro.reader().getUsename();
private String password = readpro.reader().getPassword();
public JDBCconn() {
try {
Class.forName(datatype);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
conn = DriverManager.getConnection(url, username, password);
} catch (SQLException e) {
e.printStackTrace();
}
}
public void select() {
try {
sql = "select sal from emp ";// 测试查询int基本数据类型
pstmt = conn.prepareStatement(sql);
// pstmt.setInt(1, 7369); // 测试查询int基本数据类型
// pstmt.setString(1, "CLERK");// 测试查询String类型
rs = pstmt.executeQuery();
if (rs.next() == false) {
System.out.println("no data");
} else {
System.out.println("查询结果");
System.out.println(rs.getString(1));
while (rs.next()) {
System.out.println(rs.getString(1));
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void updateEmp() {
try {
sql = "update emp set sal=sal-? where empno = ?";
// 3 创建 Statement 对象,预编译sql语句
pstmt = conn.prepareStatement(sql);
// 4 sql赋值
pstmt.setInt(1, 1); // 为第一个参数(?)赋值 1
pstmt.setInt(2, 7369); // 为第二个参数(?)赋值 7369
// 5 执行更改
pstmt.executeUpdate();
pstmt.close();
} catch (Exception e) {
e.printStackTrace();
}
}
// sql = "select sal from emp where job=?";//测试查询String类型
public void closeAll() {
try {
rs.close();
pstmt.close();
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String[] args) {
JDBCconn jc = new JDBCconn();
jc.updateEmp();
jc.select();
jc.closeAll();
}
}
利用java的jdbc连接数据库中间件
4星 · 超过85%的资源 需积分: 49 195 浏览量
2010-03-14
12:31:10
上传
评论
收藏 2KB RAR 举报
ywswen
- 粉丝: 13
- 资源: 7