java执行sql语句修改_java中怎么用sql语句做修改 增加 删除的功能 不只是sql语句，要有具体的代码...

StringBuffersqlBuffer=newStringBuffer("SELECT*FROMTS_USERwhere1=1");if(ID!=null&&!"".equals(ID)){sqlBuffer.append("ANDID="+ID);}if(tel!=null&&!"".equals(tel)){sqlBuffer.a...

StringBuffer sqlBuffer = new StringBuffer("SELECT * FROM TS_USER where 1 = 1 ");

if(ID != null && !"".equals(ID)){

sqlBuffer.append(" AND ID = " + ID);

}

if(tel != null && !"".equals(tel)){

sqlBuffer.append(" AND TEL = " + tel);

}

if(name != null && !"".equals(name)){

sqlBuffer.append(" AND NAME = " + name);

}

List userList = new ArrayList();

ResultSet rs = stmt.executeQuery(sqlBuffer.toString());

if(rs.next()){

Vector vector = new Vector();

vector.add(rs.getString("ID"));

vector.add(rs.getString("NAME"));

vector.add(rs.getString("TEL"));

vector.add(rs.getString("ADRESS"));

userList.add(vector);

这是查询的语句，那怎么做出 修改 增加 删除的功能 要有具体的代码

展开