在线等：这个ＪＳＰ程序为什么插入不了数据？

Question

PA_0能插入数据，可是PA_1插不进去，能帮忙看看是怎么回事吗？
<%
//定义数据库连接字符串，jdbc.odbc桥
String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr="jdbc:odbc:JSP";
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;//建立JDBC-ODBC桥接器
try{
Class.forName(sDBDriver);
}catch(ClassNotFoundException e){}
//连接到数据库
try{
conn=DriverManager.getConnection(sConnStr,"sa","1997cdb");
}catch(SQLException e){}try{
PreparedStatement pstmt0=conn.prepareStatement("INSERT INTO [PA_0]"+
"VALUES(?,?,?,?,?,?,?,?,?)");
//进入事务操作
conn.setAutoCommit(false);
//更新数据表PA_0字段
pstmt0.setString(1,chaoshenNO);
pstmt0.setString(2,XrayNO);
pstmt0.setString(3,payway);
pstmt0.setString(4,heartNO);
pstmt0.setString(5,CTNO);
pstmt0.setString(6,fileNO);
pstmt0.setString(7,thryNO);
pstmt0.setString(8,MRINO);
pstmt0.setString(9,DoorNO);
//执行带参数的SQL命令，但不即时更新
pstmt0.executeUpdate();
if(pstmt0!=null) pstmt0.close();
//更新数据表PA_1字段
PreparedStatement pstmt1=conn.prepareStatement("INSERT INTO [PA_1] VALUES"+
"(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,"+
"?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
pstmt1.setString(1,fileNO);
pstmt1.setString(2,ptname);
pstmt1.setString(3,ptsex);
pstmt1.setString(4,birthyear);
pstmt1.setString(5,birthmonth);
pstmt1.setString(6,birthday);
pstmt1.setString(7,ptage);
pstmt1.setString(8,ptmarriage);
pstmt1.setString(9,career);
pstmt1.setString(10,birthprov);
pstmt1.setString(11,birthcity);
pstmt1.setString(12,racial);
pstmt1.setString(13,nation);
pstmt1.setString(14,IDCardNO);
pstmt1.setString(15,workplace);
pstmt1.setString(16,workteleNO);
pstmt1.setString(17,workZipCode);
pstmt1.setString(18,liveplace);
pstmt1.setString(19,liveteleNO);
pstmt1.setString(20,liveZipCode);
pstmt1.setString(21,rname);
pstmt1.setString(22,relation);
pstmt1.setString(23,rplace);
pstmt1.setString(24,rteleNO);
pstmt1.setString(25,hosptimes);
pstmt1.setString(26,hospway);
pstmt1.setString(27,hospstatus);
pstmt1.setString(28,hospinyear);
pstmt1.setString(29,hospinmonth);
pstmt1.setString(30,hospinday);
pstmt1.setString(31,hospindep);
pstmt1.setString(32,hospinsection);
pstmt1.setString(33,hospindoc);
pstmt1.setString(34,transyear);
pstmt1.setString(35,transmonth);
pstmt1.setString(36,transday);
pstmt1.setString(37,transdep);
pstmt1.setString(38,transsection);
pstmt1.setString(39,hospoutyear);
pstmt1.setString(40,hospoutmonth);
pstmt1.setString(41,hospoutday);
pstmt1.setString(42,hospoutdep);
pstmt1.setString(43,hospoutsection);
pstmt1.setString(44,hospoutdoc);
pstmt1.setString(45,hospdays);
pstmt1.setString(46,hospdaysafter);
pstmt1.setString(47,doordiag);
pstmt1.setString(48,doordoct);
pstmt1.setString(49,hospdiag);
pstmt1.setString(50,hdiagyear);
pstmt1.setString(51,hdiagmonth);
pstmt1.setString(52,hdiagday); pstmt1.executeUpdate();
if(pstmt1!=null) pstmt1.close();
//将上述操作执行
conn.commit();
}catch(Exception e){
//若遇异常，则撤消所有操作
conn.rollback();
}
//解除事务操作
conn.setAutoCommit(true);
//关闭数据库连接
conn.close();
%>