62,614
社区成员
发帖
与我相关
我的任务
分享
public void insert(String s1,String s2){
Statement sql = null;
ResultSet rs = null;
int id = 0;
float i = 0;
String recode = null, insertStr = null;
try{
connection conn = new connection();
sql = conn.statement();
rs = conn.resultset();
rs.last();
id = rs.getInt(1)+1;
recode = "("+id+","+"'"+s1+"'"+","+"'"+s2+"'"+","+i+")";
insertStr = "INSERT INTO users VALUES "+recode;
sql.executeUpdate(insertStr);
}
catch(Exception e){
System.out.println("写入数据出错!");
}
}
public class InsertDemo {
public void insert() throws Exception{{{
Connection conn = null;
Statement stmt = null;
String sql = "INSERT INTO users VALUES ('')"
Class.forName(DBDRIVER);
conn = DriverManage.getConnetction(DBURL, DBUSER, DBPASS);
stmt = conn.createStatement();
stmt.excuteUpdate(sql);
stmt.close();
conn.close();
}
public static final String DBDRIVER =" ";
public static final String DBURL = " ";
public static final String DBUSER =" ";
public static final String DBPASS = " ";
}