数据库 CRUD操作

查询执行ResultSet rs = st.executeQuery(sql);

曾 删 改 都执行 st.executeUpdate(sql);

注意链接数据库要制定字符集，否则会出现中文乱码问题。

最后关闭连接，避免资源浪费。

package info.dyndns.oszc.Introduce;

import java.sql.*;

public class JdbcUtils {

	private static String driver = "com.mysql.jdbc.Driver";
	
	public static Connection conn(String url, String user, String password){
		try{
			Class.forName(driver);
			Connection conn = DriverManager.getConnection(url,user,password);
			
			return conn;
		}catch(Exception e){
			System.out.println("连接错误！");
			e.printStackTrace();
		}
		return null;
		
	}
	
	public static void closeDB(ResultSet rs, Statement st, Connection conn){
		if (rs!=null){
			try{
				rs.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}finally{
				if(st != null){
					try{
						st.close();
					} catch (SQLException e) {
						e.printStackTrace();
					}finally{
						if(conn!=null){
							try{
								conn.close();
							} catch (SQLException e) {
								e.printStackTrace();
							}
						}
					}
				}
			}
			
		}
		
	}
}

package info.dyndns.oszc.Introduce;

import java.sql.*;

public class CRUD {
	
	public static void creat() throws Exception{
		String url =  "jdbc:mysql://localhost:3306/comment?characterEncoding=UTF-8";
		//指定字符集 否则增加中文会乱码
		String sql = "insert into say (name,content) values('xxx','呵呵')";
		Connection conn =
				JdbcUtils.conn(url, "oszc", "1234");
		Statement st = conn.createStatement();
		st.executeUpdate(sql);
		
		JdbcUtils.closeDB(null, st, conn);
	}
	
	public static void delete() throws Exception{
		String url =  "jdbc:mysql://localhost:3306/comment?characterEncoding=UTF-8";
		String sql = "DELETE FROM say WHERE id = 123";
		Connection conn =
				JdbcUtils.conn(url, "oszc", "1234");
		Statement st = conn.createStatement();
		st.executeUpdate(sql);
		
		JdbcUtils.closeDB(null, st, conn);
	}
	
	
	
	public static void update() throws Exception{
		String url =  "jdbc:mysql://localhost:3306/comment?characterEncoding=UTF-8";
		String sql = "UPDATE say SET content='正确了！' WHERE id = 125";
		Connection conn =
				JdbcUtils.conn(url, "oszc", "1234");
		Statement st = conn.createStatement();
		st.executeUpdate(sql);
	
		JdbcUtils.closeDB(null, st, conn);
	}

	public static void read() throws Exception{
		String url =  "jdbc:mysql://localhost:3306/comment";
		String sql = "select id,name,content from say";
		Connection conn =
				JdbcUtils.conn(url, "oszc", "1234");
		Statement st = conn.createStatement();
		ResultSet rs = st.executeQuery(sql);
		while (rs.next()){
			System.out.println(rs.getObject("id")+"\t"+
		rs.getObject("name")+"\t"+rs.getObject("content")+"\t");
		}
		
		JdbcUtils.closeDB(rs, st, conn);
	}

	
	public static void main(String[] args) throws Exception {
		//CRUD.creat();
		//CRUD.update();
		//CRUD.delete();
		CRUD.read();
	}

}