昨晚

[liumin3285]

下面的2张表怎么关联以便我以后查询呢？还有这样写2个insert没问题吧！！

con=DriverManager.getConnection(url,"","");
					
con.setAutoCommit(false);//不设置自动提交
	
//save到第一张表		
pstmt=con.prepareStatement("insert into table1 value( ?, ?, ?, ?, ?, ?) " );

//数据1

//下面的save到第二张表					
pstmt=con.prepareStatement("insert into table2 value (?, ?, ?, ?, ?, ?, ?, ?)");

//数据1

//数据2

//数据3

//数据4

pstmt.addBatch();
					
con.commit();//手动提交

[bjsuo]

前一个会被后一个覆盖掉
pstmt=con.prepareStatement("insert into table1 value( ?, ?, ?, ?, ?, ?) " );

pstmt.addBatch();
pstmt=con.prepareStatement("insert into table2 value (?, ?, ?, ?, ?, ?, ?, ?)");

pstmt.addBatch();
ps.executeBatch()

[why_java]

con.setAutoCommit(false);//不设置自动提交
最好在下面设置回来。