通过JDBC-ODBC将数据插入MS Access DB

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+")");