该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
插入语句:INSERT INTO tb_scrip ('wishMan','wellWisher','color','face','content') values('"
+ SF.getWishMan()
+ "','"
+ SF.getWellWisher()
+ "',"
+ SF.getColor()
+ ","
+ SF.getFace()
+ ",'"
+ SF.getContent() + "')
执行:
System.out.println("ssssssssssssssss");
conn = getConnection();// 调用getConnection()方法构造Connection对象的一个实例conn
System.out.println("00000000000000000000000");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
System.out.println("1111111111111111111111111111a");
result = stmt.executeUpdate(sql); //执行更新操作,用于向数据表中插入数据
System.out.println("22222222222222222222222222222");
String ID = "select @@IDENTITY as id";
rs = stmt.executeQuery(ID);
if (rs.next()) {
int autoID = rs.getInt("id");
result = autoID;
System.out.println(result);
结果:执行的SQL语句:SELECT * FROM tb_scrip
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa
#aaaaaaaaaaaaaaaaaaaaaaaaaqqqqqqqqqqqqqqqqqqqa
ssssssssssssssss
00000000000000000000000
1111111111111111111111111111a
################################a
添加字条信息的SQL:INSERT INTO tb_scrip ('wishMan','wellWisher','color','face','content') values('qq','匿名',1,0,'qq')
很报谦,您的字条发送失败!
表中元素:public int id = 0; //字条编号
public String wishMan = ""; //祝福对象
public String wellWisher = ""; //祝福者
public String content = ""; //字条内容
public int color = 0; //字条颜色
public int face = 0; //心情图案
public Date sendTime = null; //发送时间
public int hits = 0;
怎么会插入不进去呢?
时间字段我想用的系统时间!