多谢你啊package search;import java.sql.*;public class date
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:url";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null;
//<!--注册数据库驱动程序-->
public date()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("date():" + e.getMessage());
}
}
//建立数据库连接及数据查询
public ResultSet executeQuery(String sql)
{
rs = null;
try
{
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:" + ex.getMessage());
}
return rs;
} //定义数据操作
public void executeUpdate(String sql)
{
//rs = null;
try
{
if(conn == null)conn = DriverManager.getConnection(sConnStr);
if(stmt == null)stmt = conn.createStatement();
stmt.executeUpdate(sql);
//stmt.close();
//conn.close();
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:" + ex.getMessage());
}
} //关闭数据库连接
public void closeStmt()
{
try
{
stmt.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
} public void closeConn()
{
try
{
conn.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
public static void main(String args[])
{
date da = new date();
String mess = "数学";
String select = "select url from urlrecord where url like '%" + mess + "%'" ;
ResultSet rs = da.executeQuery(select);
try
{
while(rs.next())
{
System.out.println(rs.getString("url"));
}
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
}
}
{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:url";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null;
//<!--注册数据库驱动程序-->
public date()
{
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("date():" + e.getMessage());
}
}
//建立数据库连接及数据查询
public ResultSet executeQuery(String sql)
{
rs = null;
try
{
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:" + ex.getMessage());
}
return rs;
} //定义数据操作
public void executeUpdate(String sql)
{
//rs = null;
try
{
if(conn == null)conn = DriverManager.getConnection(sConnStr);
if(stmt == null)stmt = conn.createStatement();
stmt.executeUpdate(sql);
//stmt.close();
//conn.close();
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:" + ex.getMessage());
}
} //关闭数据库连接
public void closeStmt()
{
try
{
stmt.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
} public void closeConn()
{
try
{
conn.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
public static void main(String args[])
{
date da = new date();
String mess = "数学";
String select = "select url from urlrecord where url like '%" + mess + "%'" ;
ResultSet rs = da.executeQuery(select);
try
{
while(rs.next())
{
System.out.println(rs.getString("url"));
}
}
catch(Exception e)
{
System.out.println(e.getMessage());
}
}
}
解决方案 »
- 一个swing应用程序卡死问题
- 关于wait和notify
- 一些java试题,有疑惑不解地方,请教.
- createStatement()和createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY)有什么区别阿?
- 要学习java了
- 下载了一份 eXtremeComponents_pdf 文件怎么打开?麻烦大家了,谢谢。
- 请问这个程序错在那里?
- 咨询个有关think in java 的问题。
- 在Java中怎么样把一个函数作为参数传递给另一个函数?(100分求助,希望各位大侠多多指点,多发表意见)
- java swing 中给table添加右键菜单
- 在jbuilder里点运行按钮运行程序时,总是弹出一个界面(run),这是为什么?请教!!!
- 有一段代码看不懂,请大家帮忙看一看.(初学者)
我也想用jdbc驱动,可是暂时没有,而且用jdbc-odbc要方便一些,
我是在自己机器上用的,数据库就在自己机子上啊,
前几天试还没有问题的,
但Statement,ResultSet要及时地关闭掉.否则会产生异常.
try
{
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
}
catch(SQLException ex)
{
} finally {
}