java 数据可连接失败抛出异常_数据库连接不上，总出现java.lang.NullPointerException错误...

代码如下：

package test;

import java.io.*;

import java.sql.*;

import javax.servlet.*;

import javax.servlet.http.*;

public class DBServlet extends HttpServlet {

/**

*

*/

private static final long serialVersionUID = 1L;

static private Connection con = null;

static private Statement st = null;

static private ResultSet rs = null;

public static Connection getConnection(){

try{

Class.forName("com.mysql.jdbc.Driver");

con=DriverManager.getConnection("jdbc:MySQL://localhost:3306/wing?user=123456&password=123456&characterEncoding=gb2312");

if(con!=null){System.out.println("连接成功!!");}

else{System.out.println("失败!!");}

} catch (ClassNotFoundException e) {e.printStackTrace();}

catch (SQLException e) {e.printStackTrace();}

return con;

}

public static ResultSet getResultSet(String sql){

con = getConnection();

try {

st = con.createStatement();

rs = st.executeQuery(sql);

} catch (SQLException e) {e.printStackTrace();}

return rs;

}

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

response.setContentType("text/html;charset=GB2312");//设置响应的MIME类型。

request.setCharacterEncoding("gb2312");

PrintWriter out = response.getWriter();

String sql = "select * from wings";

rs = getResultSet(sql);

try {

out.println("

out.println("

");

out.println("

"+"学号"+"");

out.println("

"+"姓名"+"");

out.println("

"+"性别"+"");

out.println("

"+"年龄"+"");

out.println("

");

while(rs.next()){

out.println("

");

out.println("

"+rs.getInt("ID")+"");

out.println("

"+rs.getString("name")+"");

out.println("

"+rs.getString("sex")+"");

out.println("

"+rs.getInt("age")+"");

out.println("

");

}

out.println("

");

} catch (SQLException e) {e.printStackTrace();}

}

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

doPost(request, response);

}

}

作者: Manlandyes

发布时间: 2010-08-26