我用PreparedStatement,操作数据库,但出现
java.sql.SQLException: Driver does not support this function
为什么啊?
String sql = "insert into Customer(phoneNum,name,sex,companyId,address,email)";
sql += " values(?,?,?,?,?,?)";
System.out.print(sql);
PreparedStatement psmt = conn.prepareStatement(sql);
psmt.setString(1, phoneNum);
psmt.setString(2, name);
psmt.setString(3, sex);
psmt.setInt(4, companyId);
psmt.setString(5, address);
psmt.setString(6, email);
int count = psmt.executeUpdate(sql);
java.sql.SQLException: Driver does not support this function
为什么啊?
String sql = "insert into Customer(phoneNum,name,sex,companyId,address,email)";
sql += " values(?,?,?,?,?,?)";
System.out.print(sql);
PreparedStatement psmt = conn.prepareStatement(sql);
psmt.setString(1, phoneNum);
psmt.setString(2, name);
psmt.setString(3, sex);
psmt.setInt(4, companyId);
psmt.setString(5, address);
psmt.setString(6, email);
int count = psmt.executeUpdate(sql);
楼主【mohugomohu】截止到2008-07-01 10:55:02的历史汇总数据(不包括此帖):
发帖数:69 发帖分:3065
结贴数:68 结贴分:3035
未结数:1 未结分:30
结贴率:98.55 % 结分率:99.02 %
值得尊敬
Connection conn = null;
String msg = "";
try {
conn = ConnectionUtil.getConnection();
// 获取将添加的客户信息
String phoneNum = customer.getPhoneNum();
String name = customer.getName();
String sex = customer.getSex();
int companyId = customer.getCompanyId();
String address = customer.getAddress();
String email = customer.getEmail();
String sql = "insert into Customer(phoneNum,name,sex,companyId,address,email)";
sql += " values(?,?,?,?,?,?)";
System.out.print(sql);
PreparedStatement psmt = conn.prepareStatement(sql);
psmt.setString(1, phoneNum);
psmt.setString(2, name);
psmt.setString(3, sex);
psmt.setInt(4, companyId);
psmt.setString(5, address);
psmt.setString(6, email);
int count = psmt.executeUpdate(sql);
if (count > 0) {
msg = "添加成功!";
} else {
msg = "添加失败!";
}
} catch (Exception ex) {
System.out.print(ex.toString());
msg = "系统发生错误!";
} finally {
ConnectionUtil.closeConnection(conn);
}
return msg;
}
现在用PreparedStatement,不知道为什么不行了。
String sql = "insert into Customer(phoneNum,name,sex,companyId,address,email)";
sql += " values(?,?,?,?,?,?)";
values都是问号,怎么能直接在数据库运行啊!
sql += " values(?,?,?,?,?,?)";
语法就错了
PreparedStatement psmt = conn.prepareStatement(sql);
这里已经将sql语句传进去了。
int count = psmt.executeUpdate(sql);
这里又传了sql语句进去,肯定错啊哈哈!