JDBC--Statement(添加)

第一种方法： 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);
	}
}