<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
// Java Document
package leeWebDemo1;
import java.sql. * ;
public class DBLink
{
private static Connection conn;
private Statement stmt;
private ResultSet rs;
private static final String mysqlDriver = " com.mysql.jdbc.Driver " ;
private static final String url = " jdbc:mysql://localhost:3306/mysql?user=root&password=123456 " ;
public static synchronized Connection getConn() throws Exception
{
try
{
Class.forName(mysqlDriver);
conn = DriverManager.getConnection(url);
return conn;
}
catch (SQLException e)
{
System.err.println(e.getMessage());
System.err.println(e.getMessage());
System.err.println( " 加载驱动失败! " );
throw e;
}
}
// 获取Statement 只用于查询语句
public Statement getStmtread()
{
try
{
conn = getConn();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
return stmt;
}
catch (Exception e)
{
System.err.println(e.getMessage());
e.printStackTrace();
}
return null ;
}
// 获取ResultSet
public ResultSet getRs(String sql)
{
try
{
stmt = getStmtread();
rs = stmt.executeQuery(sql);
return rs;
}
catch (Exception e)
{
System.err.println(e.getMessage());
e.printStackTrace();
}
return null ;
}
// 获取statement 与上面的getStmtread不同用于删除、更新和添加的SQL语句;
public Statement getStmt()
{
try
{
conn = getConn();
stmt = conn.createStatement();
return stmt;
}
catch (Exception e)
{
System.err.println(e.getMessage());
e.printStackTrace();
}
return null ;
}
// 关闭数据库
public synchronized void close()
{
try
{
if (rs != null )
rs.close();
rs = null ;
}
catch (Exception e)
{
System.err.println(e.getMessage());
e.printStackTrace();
}
try
{
if (stmt != null )
{
stmt.close();
stmt = null ;
}
}
catch (Exception e)
{
System.err.println(e.getMessage());
e.printStackTrace();
}
try
{
if (conn != null )
{
conn.close();
conn = null ;
}
}
catch (Exception e)
{
System.err.println(e.getMessage());
e.printStackTrace();
}
}
}
链接数据库:
// Java Document
package leeWebDemo1;
import java.sql. * ;
public class DBLink
{
private static Connection conn;
private Statement stmt;
private ResultSet rs;
private static final String mysqlDriver = " com.mysql.jdbc.Driver " ;
private static final String url = " jdbc:mysql://localhost:3306/mysql?user=root&password=123456 " ;
public static synchronized Connection getConn() throws Exception
{
try
{
Class.forName(mysqlDriver);
conn = DriverManager.getConnection(url);
return conn;
}
catch (SQLException e)
{
System.err.println(e.getMessage());
System.err.println(e.getMessage());
System.err.println( " 加载驱动失败! " );
throw e;
}
}
// 获取Statement 只用于查询语句
public Statement getStmtread()
{
try
{
conn = getConn();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
return stmt;
}
catch (Exception e)
{
System.err.println(e.getMessage());
e.printStackTrace();
}
return null ;
}
// 获取ResultSet
public ResultSet getRs(String sql)
{
try
{
stmt = getStmtread();
rs = stmt.executeQuery(sql);
return rs;
}
catch (Exception e)
{
System.err.println(e.getMessage());
e.printStackTrace();
}
return null ;
}
// 获取statement 与上面的getStmtread不同用于删除、更新和添加的SQL语句;
public Statement getStmt()
{
try
{
conn = getConn();
stmt = conn.createStatement();
return stmt;
}
catch (Exception e)
{
System.err.println(e.getMessage());
e.printStackTrace();
}
return null ;
}
// 关闭数据库
public synchronized void close()
{
try
{
if (rs != null )
rs.close();
rs = null ;
}
catch (Exception e)
{
System.err.println(e.getMessage());
e.printStackTrace();
}
try
{
if (stmt != null )
{
stmt.close();
stmt = null ;
}
}
catch (Exception e)
{
System.err.println(e.getMessage());
e.printStackTrace();
}
try
{
if (conn != null )
{
conn.close();
conn = null ;
}
}
catch (Exception e)
{
System.err.println(e.getMessage());
e.printStackTrace();
}
}
}
操作数据库
<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script><script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
//
本JavaBean包括数据的插入、更新、删除和查询等。
package leeWebDemo1.database;
import java.sql. * ;
public class DBUtil
{
private DBLink dblink = new DBLink();
private Statement stmt;
private ResultSet rs;
// 获取查询的行数:没有结果返回-1,查询异常返回-2;
public int getRowCount(String strSql)
{
int intCount = 0 ;
try {
stmt = dblink.getStmtread();
rs = stmt.executeQuery( " SELECT COUNT(*) FROM " + strSql);
if (rs.next())
{
intCount = rs.getInt( 1 );
}
else intCount =- 1 ;
}
catch (Exception e)
{
intCount =- 2 ;
}
finally
{
dblink.close();
return intCount;
}
}
// 执行插入操作
public int insert(String strSql)
{
int count = 0 ;
stmt = dblink.getStmt();
try
{
count = stmt.executeUpdate(strSql);
}
catch (Exception e)
{
count =- 2 ;
System.err.println(e.getMessage());
e.printStackTrace();
}
finally
{
dblink.close();
return count;
}
}
// 更新数据库数据
public int update(String sql)
{
int count = 0 ;
stmt = dblink.getStmt();
try
{
count = stmt.executeUpdate(sql);
}
catch (Exception e)
{
count =- 2 ;
System.err.print(e.getMessage());
e.printStackTrace();
}
finally
{
dblink.close();
return count;
}
}
// 删除数据库数据
public int delete(String sql)
{
int count = 0 ;
stmt = dblink.getStmt();
try
{
count = stmt.executeUpdate(sql);
}
catch (Exception e)
{
count =- 2 ;
System.err.println(e.getMessage());
e.printStackTrace();
}
finally
{
dblink.close();
return count;
}
}
}
package leeWebDemo1.database;
import java.sql. * ;
public class DBUtil
{
private DBLink dblink = new DBLink();
private Statement stmt;
private ResultSet rs;
// 获取查询的行数:没有结果返回-1,查询异常返回-2;
public int getRowCount(String strSql)
{
int intCount = 0 ;
try {
stmt = dblink.getStmtread();
rs = stmt.executeQuery( " SELECT COUNT(*) FROM " + strSql);
if (rs.next())
{
intCount = rs.getInt( 1 );
}
else intCount =- 1 ;
}
catch (Exception e)
{
intCount =- 2 ;
}
finally
{
dblink.close();
return intCount;
}
}
// 执行插入操作
public int insert(String strSql)
{
int count = 0 ;
stmt = dblink.getStmt();
try
{
count = stmt.executeUpdate(strSql);
}
catch (Exception e)
{
count =- 2 ;
System.err.println(e.getMessage());
e.printStackTrace();
}
finally
{
dblink.close();
return count;
}
}
// 更新数据库数据
public int update(String sql)
{
int count = 0 ;
stmt = dblink.getStmt();
try
{
count = stmt.executeUpdate(sql);
}
catch (Exception e)
{
count =- 2 ;
System.err.print(e.getMessage());
e.printStackTrace();
}
finally
{
dblink.close();
return count;
}
}
// 删除数据库数据
public int delete(String sql)
{
int count = 0 ;
stmt = dblink.getStmt();
try
{
count = stmt.executeUpdate(sql);
}
catch (Exception e)
{
count =- 2 ;
System.err.println(e.getMessage());
e.printStackTrace();
}
finally
{
dblink.close();
return count;
}
}
}