帮忙看一下这个JDBC编程中的错误

[king_3805]

// 更新表
static void upDate() {
Connection conn = getConnection();
String sql = "INSERT INTO T_SPPZ_BZ(ID,SPTXM,SPMC,GGXH,JLDW,BZQ,SCCJMC,CD,SCSJ,XGSJ,YXBZ,BZ,TBSX,CODE,QSCODE)(SELECT T_SPPZ.ID,T_SPPZ.SPTXM,T_SPPZ.GGXH,T_SPPZ.JLDW,T_SPPZ.BZQ,T_SPPZ.SCCJMC,T_SPPZ.CD,T_SPPZ.SCSJ,T_SPPZ.XGSJ,T_SPPZ.YXBZ,T_SPPZ.BZ,T_SPPZ.TBSH,T_SPPZ.CODE,T_SPPZ.QSCODE FROM WHERE T_SPPZ.SPTXM NOT IN (SELECT T_SPPZ_BZ.SPTXM FROM T_SPPZ_BZ))";
PreparedStatement sm = null;
try {
sm = conn.prepareStatement(sql);
sm.execute();
} catch (Exception e) {
e.printStackTrace();
}
}

// 执行
public static void main(String[] args) {
upDate();
System.out.println("更新成功");
}





报错信息：java.lang.NullPointerException
at Gengxin.upDate(Gengxin.java:39)
at Gengxin.main(Gengxin.java:48)

[cscript]

看下 Connection conn = getConnection();

的 conn 对象是否为空

[花谢尊前不敢香]

INSERT INTO T_SPPZ_BZ(ID,SPTXM,SPMC,GGXH,JLDW,BZQ,SCCJMC,CD,SCSJ,XGSJ,YXBZ,BZ,TBSX,CODE,QSCODE)(SELECT T_SPPZ.ID,T_SPPZ.SPTXM,T_SPPZ.GGXH,T_SPPZ.JLDW,T_SPPZ.BZQ,T_SPPZ.SCCJMC,T_SPPZ.CD,T_SPPZ.SCSJ,T_SPPZ.XGSJ,T_SPPZ.YXBZ,T_SPPZ.BZ,T_SPPZ.TBSH,T_SPPZ.CODE,T_SPPZ.QSCODE FROM WHERE T_SPPZ.SPTXM NOT IN (SELECT T_SPPZ_BZ.SPTXM FROM T_SPPZ_BZ))
你这语句能执行吗？

[致知Fighting]

conn为空

[Bumpking]

为什么要用prepareStatement呢？

[Bumpking]

prepareStatement必须要带参数吧。。。

[cscript]

[Quote=引用 2 楼 的回复:]

INSERT INTO T_SPPZ_BZ(ID,SPTXM,SPMC,GGXH,JLDW,BZQ,SCCJMC,CD,SCSJ,XGSJ,YXBZ,BZ,TBSX,CODE,QSCODE)(SELECT T_SPPZ.ID,T_SPPZ.SPTXM,T_SPPZ.GGXH,T_SPPZ.JLDW,T_SPPZ.BZQ,T_SPPZ.SCCJMC,T_SPPZ.CD,T_SPPZ.SCSJ,T_……
[/Quote]

恩 FROM 后面没有表名

不过他的错，根本就还没有执行sql就抛异常了

[king_3805]

static void upDate() {
Connection conn = getConnection();
String sql = "INSERT INTO T_SPPZ_BZ(ID,SPTXM,SPMC,GGXH,JLDW,BZQ,SCCJMC,CD,SCSJ,XGSJ,YXBZ,BZ,TBSX,CODE,QSCODE)(SELECT T_SPPZ.ID,T_SPPZ.SPTXM,T_SPPZ.SPMC,T_SPPZ.GGXH,T_SPPZ.JLDW,T_SPPZ.BZQ,T_SPPZ.SCCJMC,T_SPPZ.CD,T_SPPZ.SCSJ,T_SPPZ.XGSJ,T_SPPZ.YXBZ,T_SPPZ.BZ,T_SPPZ.TBSX,T_SPPZ.CODE,T_SPPZ.QSCODE FROM T_SPPZ WHERE T_SPPZ.SPTXM NOT IN (SELECT T_SPPZ_BZ.SPTXM FROM T_SPPZ_BZ))";
PreparedStatement sm = null;
try {
sm = conn.prepareStatement(sql);
sm.execute();
} catch (Exception e) {
e.printStackTrace();
}
}



改成这样 依然会报错：

java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1124)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:676)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:773)

[dgcxyc]

你的getConnection()函数能贴出来看看么？conn为空吧

[scbb]

[Quote=引用 7 楼 的回复:]

static void upDate() {
Connection conn = getConnection();
String sql = "INSERT INTO T_SPPZ_BZ(ID,SPTXM,SPMC,GGXH,JLDW,BZQ,SCCJMC,CD,SCSJ,XGSJ,YXBZ,BZ,TBSX,CODE,QSCODE)(SELECT T_SPPZ.ID,T_SPPZ.SPTXM……
[/Quote]

你的sql在数据库查询的地方能执行？？
貌似SQL里死锁了。

[「已注销」]

sql写错了吧 我怎么没有看见value关键字呢？

[我就要雨中漫步]

貌似是sql语句的问题，你先在数据库中执行下，看能否通过