package com;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class TestJDBC4 {
/**
* @param args
*/
Connection conn = null;
PreparedStatement pstmt=null;
ResultSet rs=null;
public static void main(String[] args) {
// insert();
// new TestJDBC4().update();
new TestJDBC4().select();
}
public void select (){
init();
try{
String sql="select * from emp where deptno = ?";
pstmt=conn.prepareStatement(sql);
//1:第一个问号的位置,10表示第一个问号的数值
pstmt.setInt(1, 10);
rs=pstmt.executeQuery();
while(rs.next()){
System.out.print(rs.getString("ename")+"\t");
System.out.println(rs.getString("deptno"));
}
close();
}catch(Exception e){e.printStackTrace();}
}
public void insert(){
init();
try{
String sql="insert into dept values(?,?,?)";
pstmt=conn.prepareStatement(sql);
pstmt.setInt(1, 11);
pstmt.setString(2, "guanliyingxiao");
pstmt.setString(3, "home");
int n=pstmt.executeUpdate();
if(n==1){
System.out.println("Ok");
}else{
System.out.println("false");
}
close();
}catch(Exception e){
e.printStackTrace();
}
}
public void delete(){
String sql="delete dept where deptno=?";
/***/
}
public void update(){
init();
try {
String sql="update dept set loc=? where deptno=?";
pstmt=conn.prepareStatement(sql);
pstmt.setString(1," xuexiao");
pstmt.setInt(2, 11);
int k=pstmt.executeUpdate();
System.out.println(k+"条记录被更改");
System.out.println((k>0)?"ok":"error");
close();
} catch (Exception e) {
e.printStackTrace();
}
}
public void init(){
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@10.12.36.201:1521:xxxxxx";
String dbUsername="scott";
String dbPassword="tiger";
conn=DriverManager.getConnection(url, dbUsername, dbPassword);
}catch(Exception e){e.printStackTrace();}
}
public void close(){
try {
if(rs!=null){
rs.close();}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(pstmt!=null){
pstmt.close();}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(conn!=null){
conn.close();}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
jdbc简单应用
最新推荐文章于 2020-04-10 15:24:15 发布