用自定义提交，写java拼json
自定义提交-https://help.fanruan.com/finereport/doc-view-3703.html
数据库连接代码：
public Connection getConnection() {
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
String url = "jdbc:sqlserver://localhost:1433;databaseName=db";
String username = "sa";
String password = "123";
Connection con = null;
try {
Class.forName(driverName);
con = DriverManager.getConnection(url, username, password);
} catch (Exception e) {
e.printStackTrace();
return null;
}
return con;
}
更新代码：
Connection conn = this.getConnection(); // 连接数据库
conn.setAutoCommit(false);
Statement st = conn.createStatement();
String upd = "UPDATE tablename set a=" + a.getValue() + " WHERE ID="+id.getValue();
st.executeUpdate(upd);
conn.commit(); // 提交
1min目标场景问卷
立即参与
