【JSP/Beans】怎么解决mysql端口被占问题?
长乐子 2004-03-21 06:43:32 平台:windows 2000 Srv + Resin2.1.9 + MySql
Q: 怎么解决mysql端口被占问题?
我的代码如下:
package jsp.beans;
import java.sql.*;
public class TestBean1 {
String url="jdbc:mysql://localhost:3306/docnmg";
String userid="root";
String userpwd="admin";
Connection DBConn;
Statement stmt;
ResultSet DBSet;
public static void main(String[] args){
try{
TestBean1 test=new TestBean1();
ResultSet rs=test.getDBSet();
while(rs.next()){
System.out.println(rs.getString(1));
}
}catch(Exception e){
e.printStackTrace();
}
}
public ResultSet getDBSet(){
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
DBConn=DriverManager.getConnection(url,userid,userpwd);
stmt=DBConn.createStatement();
DBSet=stmt.executeQuery("select * from docinfo");
}catch(Exception e){
e.printStackTrace();
}
return DBSet;
}
}
错误信息是:端口3306被占用