对数据库进行封装
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class ConnDB {
//数据库的用户名和密码
public static String username = "root";
public static String password = "";
//获得连接对象,statement对象和结果集
public static Connection conn = null;
public static Statement state = null;
public static ResultSet rs = null;
//数据库驱动,在刚开始下载的文件中
public static String driver_class = "com.mysql.jdbc.Driver";
//yanqingxiaosuo是数据库名,其他的不变
public static String url = "jdbc:mysql://localhost/yanqingxiaoshuo";
//获得数据库的连接的方法
public static Connection getConnection(){
try {
Class.forName("com.mysql.jdbc.Driver");
//指定连接类型
System.out.println("load db driver success......");
conn = DriverManager.getConnection(url,username,password);
//获取连接
System.out.println("get db connection success....");
} catch (Exception e)
{
e.printStackTrace();
}
return conn;
}
//执行数据库的查询操作,返回的为结果集
public static ResultSet excuteQuery(String sql){
try {
state = ConnDB.getConnection().createStatement();
System.out.println("get statement success....");
rs = state.executeQuery(sql);
return rs;
}
catch (Exception e)
{
e.printStackTrace();
}
return rs;
}
//关闭数据库
public static void closeDb(){
try {
if(rs != null)
rs.close();
if(state != null)
state.close();
if(conn != null)
conn.close();
}
catch (Exception e)
{ e.printStackTrace();
}
}
}
可以添加其他功能方法进行封装数据操作。
在build path进行导入数据库jdbc-connection.jar