String sql="insert into TEMPL (NUM,NAME) select "+lie1+",'"+lie2+"' from '"+chanum+"' where '"+lie1+"'='"+id+"' ";
PreparedStatement zicha=sample.prepareStatement(sql);
PreparedStatement zicha=sample.prepareStatement(sql);
//把'"+lie2+"'两边的冒号去掉就行了,一样能表示变量而且输出的时候不会再变量两边显示' '这个符号
“+变量名+”和‘“+变量名+”’都好使,但是后面会多‘’这个