第一种方法： import java.sql.connection;import java.sql.drivermanager;import java.sql.sqlexception;import java.sql.statement;public class datainsert {public static void main(string[] args) {connection con=null;statement stat=null;try {clas
第一种方法：
import java.sql.connection;import java.sql.drivermanager;import java.sql.sqlexception;import java.sql.statement;public class datainsert { public static void main(string[] args) { connection con=null; statement stat=null; try { class.forname(com.mysql.jdbc.driver); string url=jdbc:mysql://localhost:3306/db_book; con=drivermanager.getconnection(url,root,123456); stat=con.createstatement(); string sql=insert into t_user(id,username,password)values(2,'java','123'); stat.executeupdate(sql); } catch (exception e) { e.printstacktrace(); }finally{ try { stat.close(); } catch (sqlexception e) { e.printstacktrace(); } try { con.close(); } catch (sqlexception e) { e.printstacktrace(); } } }}
运行结果
第二种方法
import java.sql.connection;import java.sql.drivermanager;import java.sql.sqlexception;import java.sql.statement;public class datainsert2 { private static void add(int id,string username,string password)throws exception{ connection con=null; statement stat=null; try { class.forname(com.mysql.jdbc.driver); string url=jdbc:mysql://localhost:3306/db_book; con=drivermanager.getconnection(url,root,123456); stat=con.createstatement(); string sql=insert into t_user values(+id+,'+username+','+password+'); stat.executeupdate(sql); } catch (exception e) { e.printstacktrace(); }finally{ try { stat.close(); } catch (sqlexception e) { e.printstacktrace(); } try { con.close(); } catch (sqlexception e) { e.printstacktrace(); } } } public static void main(string[] args) throws exception { add(4,java2,123456); }}
运行结果：
第三种方法（面向对象）：
user
public class user { private int id; private string username; private string password; public user(int id, string username, string password) { super(); this.id = id; this.username = username; this.password = password; } public int getid() { return id; } public void setid(int id) { this.id = id; } public string getusername() { return username; } public void setusername(string username) { this.username = username; } public string getpassword() { return password; } public void setpassword(string password) { this.password = password; }}
public class datainsert3 { private static void add(user user) throws exception { connection con = null; statement stat = null; try { class.forname(com.mysql.jdbc.driver); string url = jdbc:mysql://localhost:3306/db_book; con = drivermanager.getconnection(url, root, 123456); stat = con.createstatement(); string sql = insert into t_user values( + user.getid() + ,' + user.getusername() + ',' + user.getpassword() + '); stat.executeupdate(sql); } catch (exception e) { e.printstacktrace(); } finally { try { stat.close(); } catch (sqlexception e) { e.printstacktrace(); } try { con.close(); } catch (sqlexception e) { e.printstacktrace(); } } } public static void main(string[] args) throws exception { user user=new user(5, java6, 123456); add(user); }}
运行结果
第四种方法（是不是有的代码写重复了）
dbutil
import java.sql.connection;import java.sql.drivermanager;import java.sql.sqlexception;import java.sql.statement;public class dbutil { public static connection getconnection() throws exception { connection con = null; try { class.forname(com.mysql.jdbc.driver); string url = jdbc:mysql://localhost:3306/db_book; con = drivermanager.getconnection(url, root, 123456); } catch (exception e) { e.printstacktrace(); } return con; } public static void close(connection con,statement stat){ try { stat.close(); } catch (sqlexception e) { e.printstacktrace(); } try { con.close(); } catch (sqlexception e) { e.printstacktrace(); } }}
import java.sql.connection;import java.sql.statement;public class datainsert4 { private static void add(user user) throws exception { connection con = null; statement stat = null; try { con=dbutil.getconnection(); stat = con.createstatement(); string sql = insert into t_user values( + user.getid() + ,' + user.getusername() + ',' + user.getpassword() + '); stat.executeupdate(sql); } catch (exception e) { e.printstacktrace(); } finally { dbutil.close(con, stat); } } public static void main(string[] args) throws exception { user user=new user(6, java7, 123456); add(user); }}
运行结果：