import java.sql.*;
/**
*<p>登录界面的JavaBean<p>
* @author datuo
*
*/
public class DB
{
Connection connect = null;
ResultSet rs = null;
public DB()
{
try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //设置驱动程序类型
}
catch(Exception e)
{
System.out.println("aaa");
e.printStackTrace();
}
}
/**
* 执行查询语句的方法
* @param sql 字符串的sql语句
* @return ResultSet对象
*/
public ResultSet executeQuery(String sql)
{
try{
/**
* 建立与数据库服务器的连接
*/
connect = DriverManager.getConnection("jdbc:mysql://localhost/test", "root", "xxxxxxxx");
Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}
catch(Exception e)
{
}
return rs;
}
/**
* 执行增,删,改语句的方法
* @param sql
* @return int
*/
public int executeUpdate(String sql)
{
int result = 0;
try{
connect = DriverManager.getConnection("jdbc:mysql://localhost/test");
Statement stmt = connect.createStatement();
result = stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println(ex.getMessage());
}
return result;
}
/**
* 关闭数据库连接的方法
*
*/
public void close()
{
if(connect != null)
{
try{
connect.close();
connect = null;
}
catch(SQLException ex)
{
System.err.println(ex.getMessage());
}
}
}
/**
*<p>登录界面的JavaBean<p>
* @author datuo
*
*/
public class DB
{
Connection connect = null;
ResultSet rs = null;
public DB()
{
try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //设置驱动程序类型
}
catch(Exception e)
{
System.out.println("aaa");
e.printStackTrace();
}
}
/**
* 执行查询语句的方法
* @param sql 字符串的sql语句
* @return ResultSet对象
*/
public ResultSet executeQuery(String sql)
{
try{
/**
* 建立与数据库服务器的连接
*/
connect = DriverManager.getConnection("jdbc:mysql://localhost/test", "root", "xxxxxxxx");
Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}
catch(Exception e)
{
}
return rs;
}
/**
* 执行增,删,改语句的方法
* @param sql
* @return int
*/
public int executeUpdate(String sql)
{
int result = 0;
try{
connect = DriverManager.getConnection("jdbc:mysql://localhost/test");
Statement stmt = connect.createStatement();
result = stmt.executeUpdate(sql);
}
catch(SQLException ex)
{
System.err.println(ex.getMessage());
}
return result;
}
/**
* 关闭数据库连接的方法
*
*/
public void close()
{
if(connect != null)
{
try{
connect.close();
connect = null;
}
catch(SQLException ex)
{
System.err.println(ex.getMessage());
}
}
}