第一种方法:
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);
}
}
运行结果: