自定义操作类 在操作数据库时更方便
package com.test;
import java.sql.*;
public class OperateSql {
private String username;
private String password;
private String url;
//private String sql;
private String sqlDriver;
private Connection conn;
private Statement stm;
private ResultSet rs;
public OperateSql(String username,String password,String url,String sqlDriver)
{
this.username = username;
this.password = password;
this.url = url;
this.sqlDriver = sqlDriver;
}
/*
* 数据库连接
*/
public void OpenLink()
{
try
{
Class.forName(this.sqlDriver);
this.conn = DriverManager.getConnection(this.url,this.username,this.password);
}
catch(Exception e)
{
System.out.println("数据库连接异常");
}
}
/*
* 执行sql查询语句
*/
public void Query(String sql)
{
//this.sql = sql;
try
{
this.stm = this.conn.createStatement();
this.rs = this.stm.executeQuery(sql);
//System.out.println(this.rs);
}
catch(Exception e)
{
System.out.println("查询操作异常");
}
}
/*
* 执行查询操作并返回一个ResultSet结果集
*/
public ResultSet select(String sql)
{
OpenLink();
Query(sql);
return this.rs;
}
/*
* 数据库更新操作
*/
public void Update(String sql)
{
OpenLink();
try
{
this.stm = this.conn.createStatement();
this.stm.executeUpdate(sql);
}
catch(Exception e)
{
System.out.println("更新操作异常");
}
}
/*
* 关闭数据库查询操作
*/
public void closeSelect()
{
try
{
stm.close();
rs.close();
conn.close();
}
catch(Exception e)
{
System.out.println("数据库关闭异常");
}
}
/*
* 关闭数据库更新操作
*/
public void closeUpdate()
{
try
{
stm.close();
conn.close();
}
catch(Exception e)
{
System.out.println("数据库关闭异常");
}
}
}
OperateSqlTest 测试操作类
package com.test;
import com.test.OperateSql;
import java.sql.*;
public class OperateSqlTest {
public static void main(String[] args) {
// TODO Auto-generated method stub
String sqlDriver = "com.mysql.jdbc.Driver";
String strUrl = "jdbc:mysql://localhost:3306/stdmng?useSSL=false";
String user = "root";
String password = "password";
OperateSql operatesql = new OperateSql(user,password,strUrl,sqlDriver);
String sql = "select name,password,age,sex,birthday from student";
ResultSet rs = operatesql.select(sql);
try {
while(rs.next())
{
try {
System.out.print(rs.getString(1)+"\t");
System.out.print(rs.getString(2)+"\t");
System.out.print(rs.getString(3)+"\t");
System.out.print(rs.getString(4)+"\t");
System.out.print(rs.getString(5)+"\t");
System.out.print("\n");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
operatesql.closeSelect();
}
}
MySql数据库student表截图和运行结果截图