天天看点

mysql插入语句在哪_求mysql插入语句在java中

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

插入语句: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;

怎么会插入不进去呢?

时间字段我想用的系统时间!