请教servlet连接数据库问题
import java.io.*;
import javax.servlet.http.*;
import javax.servlet.*;
import java.net.URL;
import java.sql.*;
public class Hi2 extends HttpServlet
{
Connection con;
public void init( ServletConfig conf) throws ServletException{
super.init();
int i=0;
String l="jdbc:mysql://localhost:3306/test?user=ODBC&useUnicode=true&characterEncoding=GBK";
try{
try{
Class.forName("org.gjt.mm.mysql.Driver");
}catch(java.lang.ClassNotFoundException e){
System.err.println("ClassNotFoundException");
System.err.println(e.getMessage());
}
con=DriverManager.getConnection(l);
System.err.println("Connected Accepted!");
}catch(SQLException ex){
while( ex!=null )
{
System.out.println("连接的数据库异常被捕捉了");
System.out.println(ex.getSQLState());
System.out.println(ex.getMessage());
System.out.println(ex.getErrorCode());
ex=ex.getNextException();
}
}
System.err.println("Connected Accepted!");
}
public void doGet(HttpServletRequest req,HttpServletResponse res) throws IOException,ServletException
{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
try{
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select * from w");
while(rs.next()){
out.println(rs.getString(1));
}
}catch(Exception e){System.out.println("this");}
}
}
为什么会出错呀？
这个是mysql数据库
问题点数：20、回复次数：1Top
1 楼Jacky1206（胖胖，其实我不胖）回复于 2004-09-02 17:15:11 得分 20
想知道为什么吗？贴出错误提示代码先！Top
