public class Jdbc {
/**
* 用PrepareStatement实现增,删,改,搜。
*/
public static void main(String[] args) {
Connection cn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
cn = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:ORCL", "scott", "huxu");
Scanner input = new Scanner(System.in);
System.out.println("请输入您选择的操作,1为增,2为删,3为改,4为搜!");
int op = input.nextInt();
switch (op) {//或者用if
case 1: {//增
String sql = "INSERT INTO teacher VALUES(?,?,?,?,?,?)";
ps = cn.prepareStatement(sql);
ps.setInt(1, 121);
ps.setString(2, "神喻");
ps.setString(3, "女");
ps.setDate(4, null);
ps.setString(5, "数据");
ps.setString(6, "计算机系");
ps.executeUpdate();
break;
}
case 2: {//删
String sql = "DELETE FROM teacher WHERE TNO=?";
ps = cn.prepareStatement(sql);
ps.setInt(1, 121);
ps.executeUpdate();
break;
}
case 3: {//改
String sql = "UPDATE teacher SET PROF=? WHERE TNO=?";
ps = cn.prepareStatement(sql);
ps.setString(1, "神经");
ps.setInt(2, 900);
ps.executeUpdate();
break;
}
case 4: {//查
String sql = "SELECT * FROM teacher WHERE SEX LIKE ?";
ps = cn.prepareStatement(sql);
ps.setString(1, "%女%");
rs = ps.executeQuery();
while (rs.next()) {
System.out.println(rs.getInt("TNO") + " "
+ rs.getString("TNAME") + " "
+ rs.getString("SEX"));
}
break;
}
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (rs != null)
rs.close();
if (ps != null)
ps.close();
if (cn != null)
cn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
JDBC技术学习 https://www.itkc8.com