public class JDBCTEST { @Test
public void doSearch() throws ClassNotFoundException,SQLException{
String driverName="oracle.jdbc.OracleDriver";
String url="jdbc:oracle:thin:@localhost:1521:myoracle";
String usr="scott";
String pas="tiger";
Connection con=null;
Class.forName(driverName);
con=DriverManager.getConnection(url, usr, pas);
Statement stmt=con.createStatement();
con.setAutoCommit(false);
stmt.executeUpdate("CREATE TABLE C" + "(id VARCHAR(32) ,name VARCHAR(32),age NUMBER,score NUMBER)");
stmt.executeUpdate ("INSERT INTO C" + "VALUES ('075','joyce',22,90)");
stmt.executeUpdate("INSERT INTO C" + "VALUES ('071','LILY',23,80)");
stmt.executeUpdate("INSERT INTO C" + "VALUES ('072','MOMO',22,88)");
PreparedStatement updatename = con.prepareStatement("UPDATE C SET name = ? WHERE age = ?");
updatename.setInt(3, 23);
updatename.setString(2,"DELL");
updatename.executeUpdate();
con.commit();
con.setAutoCommit(true);
String sql="SELECT C.id, C.name from C";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
System.out.print(rs.getString(1)+" ");
System.out.println(rs.getString(2));
}
rs.close();
stmt.close();
con.close();
}
}老是报java.sql.SQLException: ORA-00928: 缺失 SELECT 关键字
stmt.executeUpdate ("INSERT INTO C" + "VALUES ('075','joyce',22,90)");这哪里错了??
public void doSearch() throws ClassNotFoundException,SQLException{
String driverName="oracle.jdbc.OracleDriver";
String url="jdbc:oracle:thin:@localhost:1521:myoracle";
String usr="scott";
String pas="tiger";
Connection con=null;
Class.forName(driverName);
con=DriverManager.getConnection(url, usr, pas);
Statement stmt=con.createStatement();
con.setAutoCommit(false);
stmt.executeUpdate("CREATE TABLE C" + "(id VARCHAR(32) ,name VARCHAR(32),age NUMBER,score NUMBER)");
stmt.executeUpdate ("INSERT INTO C" + "VALUES ('075','joyce',22,90)");
stmt.executeUpdate("INSERT INTO C" + "VALUES ('071','LILY',23,80)");
stmt.executeUpdate("INSERT INTO C" + "VALUES ('072','MOMO',22,88)");
PreparedStatement updatename = con.prepareStatement("UPDATE C SET name = ? WHERE age = ?");
updatename.setInt(3, 23);
updatename.setString(2,"DELL");
updatename.executeUpdate();
con.commit();
con.setAutoCommit(true);
String sql="SELECT C.id, C.name from C";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()){
System.out.print(rs.getString(1)+" ");
System.out.println(rs.getString(2));
}
rs.close();
stmt.close();
con.close();
}
}老是报java.sql.SQLException: ORA-00928: 缺失 SELECT 关键字
stmt.executeUpdate ("INSERT INTO C" + "VALUES ('075','joyce',22,90)");这哪里错了??
解决方案 »
- ExtJs有个Window,然后有个属性html(iframe),到另外一个页面,然后在另外页面关闭,同时关闭window
- JSP 数据库问题
- 再求一个sql,立即给分
- 散分:北京同尚阳光科技开发有限公司
- Struts2 如何将服务器返回的HTML标签字符串解析成HTML标签?
- 请教高手,关于FRAMESET一个很奇怪的问题。。解决马上给分
- Liferay 开源门户
- 我这里有个 国内一家知名公司开发的erp软件, 我有原码,谁要?
- 如何把字符串性的日期变量副给日期型变量,给50分
- spring mvc session管理的问题
- 初学者 session 简单的页面跳转问题
- 2天未解决的问题 各位帮帮忙
==>
stmt.executeUpdate ("INSERT INTO C " + "VALUES ('075','joyce',22,90)");
ps: c与values连起来了updatename.setInt(3, 23);
==>
updatename.setInt(1, 23);//索引错误!
还有楼上大哥谢谢+sorry,贴结不了,分给不出,突然发现小女子我全身家当就几分,我想给也给不出