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

运行结果：