Question

java sql语句引用变量

smt = connection.prepareStatement("create table "+"'NewTableName'"+"(num int IDENTITY (1,1) PRIMARY KEY,time varchar(50),src_port int,"
+ "dst_port int,src_ip varcahr(10),dst_ip varchar(10),len int,protocol varchar(10) )");

sql语句中引用了字符串变量NewTableName作为 新创建的表的名字 有什么问题吗？

Answer 1

smt = connection.prepareStatement("create table "+‘"NewTableName'’+"(num int IDENTITY (1,1) PRIMARY KEY,time varchar(50),src_port int,"
+ "dst_port int,src_ip varcahr(10),dst_ip varchar(10),len int,protocol varchar(10) )");
你要加变量进去，是用双引号隔开里面在用单引号放入变量，希望能帮助到你

Answer 2

可以用？号

Answer 3

不知道耶，围观