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