Question

请教高手,帮我看看连接MYSQL的代码哪错了????

前面一段是对的,可以用!!!!为什么后面一段我的就连不上,真气人啊!!
import java.sql.Connection;
import java.sql.DriverManager;

public class ConnectionUtil {
private String driver="com.mysql.jdbc.Driver";

private String url = "jdbc:mysql://localhost:3306/333?user=root&password=test&useUnicode=true";

public Connection getConnection() {
try {
Class.forName(driver);
return DriverManager.getConnection(url);
} catch (Exception e) {
e.printStackTrace();
}
return null;
}

public static void main(String[] args) {
ConnectionUtil cu = new ConnectionUtil();
Connection conn = cu.getConnection();
System.out.println(conn);
}

}
我的代码
package cao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

import org.apache.struts.action.Action;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

import chaoren.GoodsForm;
import java.sql.*;

public class GoodsAction extends Action {
GoodsForm goodsform=null;
private int categoreyId =0;
public ActionForward execute(ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response) throws Exception {
goodsform=new GoodsForm();
categoreyId=Integer.parseInt(request.getParameter("id"));
String dbDriver = "com.mysql.jdbc.Driver"; // 数据库的驱动
String url="jdbc:mysql://localhost:3306/333?user=root&password=test&useUnicode=true"; // URL地址
Connection connection = null;
try {
Class.forName(dbDriver); // 加载数据库驱动
connection = DriverManager.getConnection(url);// 加载数据库
} catch (Exception ex) {
System.out.println("数据库加载失败");
}
PreparedStatement ps = null;
ps = connection.prepareStatement("select max(ID)+1 as ID from dept where categoreyId="+categoreyId+"");
ResultSet rs=ps.executeQuery();
while(rs.next())
goodsform=new GoodsForm();
goodsform.setCode(rs.getString("ID"));
System.out.println(goodsform.getCode());
request.setAttribute("codes", goodsform);
return mapping.findForward("good");}
}

错误提示:
3
数据库加载失败
2009-11-5 11:54:43 org.apache.struts.action.RequestProcessor processException
警告: Unhandled Exception thrown: class java.lang.NullPointerException
2009-11-5 11:54:43 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet action threw exception
我有项目包,谁能帮忙看看的感激不禁

Answer 1

加我扣扣7035963帮你解决。是数据库连接的问题
报空指针是因为 数据库连接不上 Connection获取不到的原因.

Answer 2

兄弟，同是天涯沦落人啊，我也是，气死我了，都！！，你要是搞出来了，记得告诉我一下，谢谢！！！

Answer 3

代码太乱了

Answer 4

categoreyId=Integer.parseInt(request.getParameter("id"));
？这个参数哪里来的
报的是空指针异常那么肯定有一个对象为空 或者一个值没获取到

Answer 5

代码太乱了