查询执行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();
- }
- }