UC知道已经连接上数据库，怎样从java程序中插入数据到sql server2000？
来源：百度知道 编辑：UC知道 时间：2024/06/19 03:47:19
部分程序如下：
String sql="insert into basicinformation values('"+id+"','"+name+"',"+sexbit+",'"+born+"','"+worktime+"','" +department+"','"+duty+"','"+status+"',"+ismarrybit;
PreparedStatement state=con.getConnection().prepareStatement(sql);
System.out.println(born); //这条语句能执行
state.setString(1, id);
state.setString(2, name);
state.setBoolean(3, sexbit);
state.setDate(4, born);
state.setDate(5, worktime);
state.setString(6, department);
state.setString(7, duty);
state.setString(8, status);
state.setBoolean(9, ismarrybit);
state.execute();
String sql="insert into basicinformation values('"+id+"','"+name+"',"+sexbit+",'"+born+"','"+worktime+"','" +department+"','"+duty+"','"+status+"',"+ismarrybit;
PreparedStatement state=con.getConnection().prepareStatement(sql);
System.out.println(born); //这条语句能执行
state.setString(1, id);
state.setString(2, name);
state.setBoolean(3, sexbit);
state.setDate(4, born);
state.setDate(5, worktime);
state.setString(6, department);
state.setString(7, duty);
state.setString(8, status);
state.setBoolean(9, ismarrybit);
state.execute();
首先，在sql的最后少了个“)”，
其次，你要么是直接执行已经拼接好的sql文，就是那个String sql，要么就在这个sql里面把所有变量都用 ？来代替，然后用预处理过程来给每个问号逐个set值，像你前面已经拼接好了sql文，就用不到后面的state.set处理了。