jdbc+oracle数据库 PreparedStatement实现增删该查

这里写代码片import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Time;
import java.text.SimpleDateFormat;

public class zsgc {
public static boolean ChaRu3() {
boolean flag = true;
String url = “jdbc:oracle:thin:@localhost:1521:orcl”;
String user = “caj”;
String password = “123456”;
Connection conn = null;
PreparedStatement ps = null; // 创建PreparedStatement 对象
String sql = “insert into temp (eno,ename,mytime) values(?,?,?)”; // sql语句不再采用拼接方式，应用占位符问号的方式写sql语句。
try {
Class.forName(“oracle.jdbc.OracleDriver”);
conn = DriverManager.getConnection(url, user, password);
ps = conn.prepareStatement(sql);
ps.setString(1, “6”); // 对占位符设置值，占位符顺序从1开始，第一个参数是占位符的位置，第二个参数是占位符的值。
ps.setString(2, “juan”);
Date date = new Date(new java.util.Date().getTime());
ps.setDate(3, date);
int i = ps.executeUpdate();
if (i == 0) {
flag = false;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return flag;
}
public static boolean XiuGai3(){
boolean flag=true;
String url = “jdbc:oracle:thin:@localhost:1521:orcl”;
String user = “caj”;
String password = “123456”;
Connection conn=null;
PreparedStatement ps=null;
String sql=”update temp set ename=? where eno=?”;
try {
Class.forName(“oracle.jdbc.OracleDriver”);
conn = DriverManager.getConnection(url, user, password);
ps=conn.prepareStatement(sql);
ps.setString(1,”chen”);
ps.setString(2,”1”);
int i= ps.executeUpdate();//返回更新记录的行数
if(i==0){
flag=false;
}

} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return flag;
}
public static boolean ShanChu3(int id){
boolean flag=true;
String url = “jdbc:oracle:thin:@localhost:1521:orcl”;
String user = “caj”;
String password = “123456”;
Connection conn=null;
PreparedStatement ps=null;
String sql=”delete from temp where eno= ?”;
try {
Class.forName(“oracle.jdbc.OracleDriver”);
conn = DriverManager.getConnection(url, user, password);
ps=conn.prepareStatement(sql);
ps.setInt(1, id);
int i=ps.executeUpdate();//返回删除记录的行数
if(i==0){
flag=false;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

return flag;
}
public static void ChaKan3(){
String url = “jdbc:oracle:thin:@localhost:1521:orcl”;
String user = “caj”;
String password = “123456”;
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
String sql=”select * from temp”;
try {
Class.forName(“oracle.jdbc.OracleDriver”);
conn = DriverManager.getConnection(url, user, password);
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
while(rs.next()){
System.out.print(rs.getString(“eno”));
System.out.println(rs.getString(“ename”));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void main(String[] args) {
ChaRu3();
//XiuGai3();
//ShanChu3(6);
//ChaKan3();
}

}