java - 数据库查询插入无法正常工作

Question

status 的值变为 false 而不是 true。我在数据库中分别使用了相同的插入查询，它正在工作，但在这里它不是。我要插入值的表包含 4 列 departmentid，departmentname , company, place 和departmentid 自增。有人可以更正一下吗。

package bean;
import java.sql.*;


public  class LoginDao {
public static boolean validate(LoginBean bean){
    boolean status=false;
    try{
        Connection con=ConnectionProvider.getCon();
        String sql="insert into department(departmentname,company,place)   values (?,?,?)";            
        PreparedStatement pstmt =con.prepareStatement(sql);
        pstmt.setString(2,bean.getdepartment()); 
        pstmt.setString(3,bean.getcompany());
        pstmt.setString(4, bean.getplace());

        int rs=pstmt.executeUpdate();
        if(rs>0){status=true;}
    }catch(Exception e){}

    return status;
 }
}

在

pstmt.setString(2,bean.getdeparment());               
pstmt.setString(3,bean.getcompany());
pstmt.setString(4, bean.getplace());

我把索引值分别改成1,2,3还是不行。

此文件是 loginbean，getdepartment()、getcompany、getplace 方法来自该文件。 包 bean ；

public class LoginBean {
private String company,department,place;

public String getcompany() {
    return company;
}

public void setcompany(String company) {
    this.company = company;
}

public String getdepartment() {
    return department;
}

public void setdepartment(String department) {
    this.department = department;
}

public String getplace() {
    return place;
}

public void setplace(String place) {
    this.place = place;
}  

}

Answer 1

你好试试这段代码，确保你插入的值与部门表列具有相同的数据类型，希望它能工作。

String sql="insert into department values(?,?,?)";            
    PreparedStatement pstmt =con.prepareStatement(sql);
    pstmt.setString(1,bean.getdepartment()); 
    pstmt.setString(2,bean.getcompany());
    pstmt.setString(3, bean.getplace());