package sjob;
import java.sql.*;
public class connBook
{
private Statement state=null;
private Connection conn = null;
ResultSet results=null;
public connBook() { }
public void openConn()throws Exception //连接数据库
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:book";
conn=DriverManager.getConnection(url,"",""); //数据库、用户名、密码 ，创建连接对象
}
catch(SQLException e) //异常处理
{
System.err.println("Data.executeQuery: " +e.getMessage());
}
}
public ResultSet queryResult(String query)
{
results = null;
try
{
state=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); //创建访问数据库的对象
results=state.executeQuery(query); //查询并返回结果
}
catch(SQLException e)
{
System.err.println("Data.executeQuery: " + e.getMessage());
}
return results;
}
public void closeState()
{
try
{
state.close(); //关闭访问数据库的对象
}
catch(SQLException e)
{
System.err.println("Date.executeQuery: " + e.getMessage());
}
}
public void closeConn()
{
try
{
conn.close(); //断开连接
}
catch(SQLException e)
{
System.err.println("Data.executeQuery: " + e.getMessage());
}
}
}
