菜鸟求助！关于plsql的问题。
下面这段java程序，可以实现从数据库中读出数据，输出到控制台；
package com.task4;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class LookUp {
public static void main(String[] args) {
try{
String dbUrl = "jdbc:oracle:thin:@Bard0117:1522:ORCL";
String user="system";
String password="system";
Connection conn = null;
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(dbUrl,user,password);
Statement s=conn.createStatement();
String sql = "select NAME,BIRTHDAY from TBL_TEST_CLASS1 t ";
ResultSet r=s.executeQuery(sql);//处理查询结果
while(r.next()){
System.out.print(r.getString(1));//读取每条记录的第一个字段//
}s.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
现在要写一个方法，把“张三”改成“张山”并输出修改后的结果；然后删除张山，把李四加进去。sql语句如下，怎样写这个方法？
String sql = "update TBL_TEST_CLASS2 set NAME='张山' where NAME='张三';";
String sql = "DELETE FROM TBL_TEST_CLASS1 WHERE NAME = '张山'";
String sql="INSERT INTO TBL_TEST_CLASS1 (USER-CODE,NAME,BIRTHDAY) VALUES('lisi','李四','19880808')";
[解决办法]
被你说的有点晕，直接 s.execute(sql) 不就完成了？
[解决办法]
你这个事纯苦力活啊……先写给你， 应该可以的 你试试看……
package test;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class LookUp { public void execute(Connection conn, String sql) { PreparedStatement pstmt = null; try { pstmt = conn.prepareStatement(sql); ResultSet rs = pstmt.executeQuery(); while (rs.next()) { System.out.print(rs.getString(1));// 读取每条记录的第一个字段// } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { closePstmt(pstmt); } } public void update(Connection conn, String sql) { PreparedStatement pstmt = null; try { pstmt = conn.prepareStatement(sql); pstmt.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { closePstmt(pstmt); } } /** * 关闭PreparedStatement * * */ private void closePstmt(PreparedStatement pstmt) { try { if (pstmt != null && !pstmt.isClosed()) { pstmt.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } public static void main(String[] args) { String selectSql = "select NAME,BIRTHDAY from TBL_TEST_CLASS1 t "; String updateSql = "update TBL_TEST_CLASS2 set NAME='张山' where NAME='张三';"; String deleteSql = "DELETE FROM TBL_TEST_CLASS1 WHERE NAME = '张山'"; String insertSql="INSERT INTO TBL_TEST_CLASS1 (USER-CODE,NAME,BIRTHDAY) VALUES('lisi','李四','19880808')"; LookUp lookUp = new LookUp(); Connection conn = null; try { String dbUrl = "jdbc:oracle:thin:@Bard0117:1522:ORCL"; String user = "system"; String password = "system"; Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection(dbUrl, user, password); //第一次查询 lookUp.execute(conn, selectSql); //把“张三”改成“张山” lookUp.update(conn, updateSql); //输出修改后的结果 lookUp.execute(conn, selectSql); //删除张山 lookUp.update(conn, deleteSql); //把李四加进去 lookUp.update(conn, insertSql); } catch (Exception e) { e.printStackTrace(); } finally { try { //关闭connection if (conn != null && !conn.isClosed()) { conn.close(); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } }}
[解决办法]
查询用s.executeQuery(sql);
update，delete，insert用 s.executeUpdate(sql);
[解决办法]