Java GUI + MySQL ทำปุ่มแก้ไขข้อมูล รันได้ แต่เออเร่อตอนกดปุ่ม prepareStatement
Code (Java) String sql ="UPDATE employee SET employeeID = ?, EName = ?, ESname = ?, EAddress = ?, ETel = ?, ESalary = ?, EPosition = ?, EBirthday = ?, EStartdate = ? WHERE employeeID = ?" ;
try{
java.sql.Connection c = db.getConnection();
PreparedStatement pre = c.prepareStatement(sql);
// set ค่า ลงไป
pre.setString(1,txtIDemp.getText());
pre.setString(2,txtName.getText());
pre.setString(3,txtLname.getText());
pre.setString(4,txtaddress.getText());
pre.setString(5,txttel.getText());
pre.setString(6,txtSalary.getText());
pre.setString(7,txtPosition.getText());
pre.setString(8,txtBirth.getText());
pre.setString(9,txtStart.getText());
pre.setString(10,txtIDemp.getText());
if(c.createStatement().executeUpdate(sql)!=-1){
JOptionPane.showMessageDialog(this,"แก้ไขข้อมูลเรียบร้อยแล้ว");
showData();
}
}catch(Exception e){
e.printStackTrace();}
Code com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?,EName=?,ESname=?,EAddress=?,ETel=?,ESalary=?,EPosition=?,EBirthday=?,EStartdat' at line 1
Tag MySQL, JAVA
Date :
2013-03-05 13:25:45By :
ampreawView :
2796Reply :
5
ถ้าเปลี่ยนเป็น pre โค้ดมันเออเร่ออ่าค่ะ
Date :
2013-03-05 14:45:01By :
ampreaw
Code (Java) pre.executeQuery();
Date :
2013-03-05 14:49:32By :
mr.win
มันไม่ได้อ่าค่ะ T__T
Date :
2013-03-05 15:11:13By :
ampreaw
Code (Java) Class.forName("com.mysql.jdbc.Driver");
connect = DriverManager.getConnection("jdbc:mysql://localhost/mydatabase" +
"?user=root&password=root");
String sql = "UPDATE customer " +
"SET Budget = ? " +
" WHERE CustomerID = ? ";
pre = connect.prepareStatement(sql);
pre.setFloat(1, 5000000);
pre.setString(2, "C005");
pre.executeUpdate();
Java MySQL Database and PreparedStatement/Parameters Query (JDBC)
Date :
2013-08-11 08:41:57By :
mr.win
Server 04
Load balance : Server 04
Quote:
