麻烦看看此javabean是否正确？tomcat连接mysql 谢谢。
package opendb;
import java.sql.*;
import java.lang.*;
public class opendb
{
String strDBDriver="org.gjt.mm.mysql.Driver";
String strDBUrl="jdbc:mysql://localhost:/mysitedate";
private Connection conn=null;
private Statement stmt=null;
ResultSet rs=null;
//注册数据库驱动程序
public opendb()
{
try
{
Class.forName(strDBDriver);
}
//异常处理
catch( java.lang.ClassNotFoundException e)
{
System.err.println("opendb():"+e.getMessage());
}
}
//建立数据库连接及定义数据查询
public ResultSet executeQuery(String sql)
{
rs=null;
try
{
conn=DriverManager.getConnection(strDBUrl,"root","");
stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex)
{
System.err.println("ap.executeQuery:"+ex.getMessage());
}
return rs;
}
//定义数据操库作
public void executeUpdate(String sql)
{
stmt=null;
rs=null;
try
{
conn=DriverManager.getConnection(strDBUrl,"root","");
stmt=conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex)
{
System.err.println("ap.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();
}
}
}
问题点数：20、回复次数：3Top
1 楼yxhzj（余华[学习J2EE中]）回复于 2005-05-31 15:52:16 得分 10
没怎么看,帮助顶Top
2 楼zsl0627（小弟）回复于 2005-05-31 16:53:10 得分 0
顶啊 没人理啊？555555555555555555555Top
3 楼jyy7751（wish i could fly）回复于 2005-05-31 17:45:15 得分 10
public static MysqlConnection getMysqlConnection()
throws SitException{
Connection conn = null;
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://127.0.0.1/weborder?user=sa&password=&useUnicode=true&characterEncoding=GBK";
url ="jdbc:mysql://127.0.0.1/weborder?user=sa&password=&useUnicode=true&characterEncoding=GBK";
conn= DriverManager.getConnection(url,"sa","");
}catch(Exception e){
throw new SitDbException("数据库取连接错误");
}
return new MysqlConnection(conn);
}Top
