JDBC -- Statement (ADD)

Method 1: importjava. SQL. connection; importjava. SQL. driverManager; importjava. SQL. SQLException; importjava. SQL. statement; publicclassDataInsert {publicstaticvoidmain (String [] args) {Connectionconnull; Statementstatnull; try {Clas

Method 1: 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

Method 1:

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();}}}}

Running result

Method 2

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");}}

Running result:

Method 3 (Object-Oriented ):

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);}}

Running result

Method 4 (if some code is already written)

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);}}

Running result: