Driver does not support this function

[mohugomohu]

我用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);

[zzkk_1980]

眼拙了

[zidasine]

还是楼主眼力好啊

[lisl2003]

[Quote=引用 9 楼 zzkk_1980 的回复:]
眼拙了
[/Quote]

[liuyangccu]

学习中...

[mjgwf]

很厉害，值得学习，呵呵！

[zhj92lxs]

sql没错，怪

[mohugomohu]

	public String insertCustomer(CustomerObj customer) {// 添加客户
		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;
	}

[lisl2003]

能不能先尝试直接在数据库上执行你的sql语句试试？

[mohugomohu]

我原来是用Statement直接拼凑sql语句，没有任何问题。
现在用PreparedStatement，不知道为什么不行了。
String sql = "insert into Customer(phoneNum,name,sex,companyId,address,email)";
sql += " values(?,?,?,?,?,?)";
values都是问号，怎么能直接在数据库运行啊！

[叶涛网站推广优化]

String sql = "insert into Customer(phoneNum,name,sex,companyId,address,email)";
sql += " values(?,?,?,?,?,?)";




语法就错了

[mohugomohu]

看来大家还是要练练眼力啊，
PreparedStatement psmt = conn.prepareStatement(sql);
这里已经将sql语句传进去了。
int count = psmt.executeUpdate(sql);
这里又传了sql语句进去，肯定错啊哈哈！

[awusoft]

呵呵......