public boolean addClerkId(String clerkId, String name) {
try {
Connection conn = (Connection) MySqlConnection.getMySqlConnection()
.getConnection();
PreparedStatement ps = conn
.clientPrepareStatement("update clerk set clerkId="
+ clerkId + " where name=" + name + "");
ps.executeUpdate();
return true;
} catch (Exception e) {
e.printStackTrace();
}
return false;
}
"update clerk set clerkId="+ clerkId + " where name=" + name + ""
这个怎样用把name和clerkId写进mysql里面?
try {
Connection conn = (Connection) MySqlConnection.getMySqlConnection()
.getConnection();
PreparedStatement ps = conn
.clientPrepareStatement("update clerk set clerkId="
+ clerkId + " where name=" + name + "");
ps.executeUpdate();
return true;
} catch (Exception e) {
e.printStackTrace();
}
return false;
}
"update clerk set clerkId="+ clerkId + " where name=" + name + ""
这个怎样用把name和clerkId写进mysql里面?
("update clerk set clerkId="+ clerkId + " where name=" + name + "");
怎么样把clerkId和name传进去,
功能是这样的
可是update clerk set clerkId="+ clerkId + " where name=" + name + " 这条语句执行不了 也就是"+ clerkId + "写法有问题
JSP里的字符串连接,是用+号么??
public boolean addClerkId(String clerkId, String name) {
try {
String sqlquery = "update clerk set clerkId=? where name=?";
Connection conn = (Connection) MySqlConnection.getMySqlConnection().getConnection();
PreparedStatement ps = conn.prepareStatement(sqlquery);
ps.setString(1, clerkId);
ps.setString(2, name);
ps.executeUpdate();
return true;
} catch (Exception e) {
e.printStackTrace();
}
return false;
}
真的很感谢你,一下就解决了我的问题 我还想问您一个问题 public boolean clerkId(String name) {
try {
Connection conn = (Connection) MySqlConnection.getMySqlConnection()
.getConnection();
Statement sm = conn.createStatement();
ResultSet rs = sm.executeQuery("select clerkId from clerk where name="+name+"");
while (rs.next()) {
if (rs.getString("clerkId").equals("")) {
return true;
}
}
} catch (SQLException e) {
e.printStackTrace();
}
return false;
}这个里面的name怎么写?
ResultSet rs = sm.executeQuery("select clerkId from clerk where name='"+name+"'");看看
Connection conn = (Connection) MySqlConnection.getMySqlConnection().getConnection();
PreparedStatement ps = conn.prepareStatement(sqlquery);
ps.setString(1, name);
ResultSet rs = ps.executeQuery();
while (rs.next()) {
...
}