JDBC封装、使用

JDBC封装、使用

---

封装jdbc

package com.ywjk.util;

import java.sql.*;

public class jdbc {

    private Connection conn = null;
    private String sql;
    private String url = "jdbc:mysql://localhost:3306/mydatebase?"
            + "user=root&password=password&useUnicode=true&characterEncoding=UTF8";

    /*
    * 创建连接
    */
    public Connection createsqllink(){
        try {
            Class.forName("com.mysql.jdbc.Driver");// 动态加载mysql驱动
            this.conn = DriverManager.getConnection(this.url);
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        return this.conn;
    }

    /*
    * 执行代码,返回结果集
    */
    public ResultSet executeQuery(String executesql) {
        Statement statement = null;
        ResultSet resultSet = null;
        try {
            statement = this.conn.createStatement();
            resultSet = statement.executeQuery(executesql);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return resultSet;
    }

    /*
    * 执行代码,返回影响行数
    */
    public int executeQueryline(String executesql) {
        Statement statement = null;
        int result = 0;
        try {
            statement = conn.createStatement();
            result = statement.executeUpdate(sql);
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return result;
    }

    /*
    * 关闭连接
    */
    public void closesqllink(){
        try {
            this.conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

使用

 public String GetSqlByYwflbs(int my_ywflbs){
        jdbc myjdbc = new jdbc();
        String sqlyj = "";
        try {
            //创建连接
            Connection conn = myjdbc.createsqllink();
            //执行语句
            String execute_sql = "select * from test where bs = '"+my_ywflbs+"';";
            //执行
            Statement statement = conn.createStatement();
            ResultSet re = statement.executeQuery(execute_sql);
            while (re.next()) {
                sqlyj = re.getString("sqlyj");
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        //关闭连接
        myjdbc.closesqllink();
        //返回数据
        return sqlyj;
    }