select 可以查询 update不能修改原因是 能否贴出完整代码

[php413611108]

update


脚本胆码

jsp代码
<%@ page import="java.sql.*" %>

<%@ page import="java.util.*" %>

<%@ page import="java.io.*" %>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

<form>

<textarea rows="4" cols="60" name="query"></textarea></br>

<button type="submit">executeQuery</button>

</form>

<%

try {

String sql = request.getParameter("query");

out.println(sql+"</br>");

String driver = "oracle.jdbc.OracleDriver";

String url = "jdbc:oracle:thin:@192.168.1.245:1521:urpjw";

String username = "newjw";

String password = "BC_newjw_##";
Class.forName(driver).newInstance();
Connection conn = DriverManager.getConnection(url,username,password);

Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery(sql);

ResultSetMetaData rsmd = rs.getMetaData();

int num = rsmd.getColumnCount();

while(rs.next()) {

for (int i=1; i<=num; i++){



out.println(rs.getString(i)+" ");

}

out.println("</br>");

}

rs.close();

stmt.close();

conn.close();

} catch (Exception e) {

response.setStatus(200);

e.printStackTrace();

}
%>

[陈灬风]

你没有唯一列，如果值存在重复，就update不了，你是不是有重复数据。如果是那么试试用rowid处理