java通过JDBCODBC将数据插入MS Access数据库

Question

我试图将java中的一些数据插入我的数据库（ms.access），但当我单击按钮时，什么也不添加到数据库中。代码如下：

private void EmpButtonMouseClicked(java.awt.event.MouseEvent evt) {        
    String name,sex,email,username,password;
    name = tfName.getText();
    sex=(String) cbSex.getSelectedItem();
    email=tfEmail.getText();
    username=tfUser.getText();

    try{
        String url;
        url = "jdbc:odbc:mydata";
        Connection conn = DriverManager.getConnection(url,"",""); 
        Statement stm = conn.createStatement();
        stm.executeUpdate("INSERT INTO EmployeeLogin " + "VALUES (name, email, sex, username)");
        conn.close();
    }catch (SQLException sqlException){} 
} 

那代码怎么了

Answer 1

我想我找到了做这件事的方法

String sex=(String) cbSex.getSelectedItem();
    try{
        String url = "jdbc:odbc:mydata";
        Connection conn = DriverManager.getConnection(url,"","");
        String sql = "INSERT INTO CustomerLogin(Name, Email, Sex, Username, Password) VALUES(?,?,?,?,?)";     
pst=conn.prepareStatement(sql);
pst.setString(1, tfName.getText());
pst.setString(2, tfEmail.getText());
pst.setString(3, sex);
pst.setString(4, tfUser.getText());
pst.setString(5, pfPassword.getText());

pst.execute();
tfName.setText("");
tfEmail.setText("");
tfUser.setText("");
pfPassword.setText("");
JOptionPane.showMessageDialog(null,"Succed Create Account! You can now return to Login Page");


        }catch (Exception e){
        JOptionPane.showMessageDialog(null,e); }

Answer 2

问题是：

stm.executeUpdate("INSERT INTO EmployeeLogin " + "VALUES (name, email, sex, username)");

写得像：

stm.executeUpdate("INSERT INTO EmployeeLogin VALUES ("+name+", "+email+", "+sex+", "+username+")");