jsp连接内部服务器错误mysql_jsp mysql连接错误

//1.设定编码request.setCharacterEncoding("utf-8");response.setCharacterEncoding("utf-8");response.setContentType("text/html;charset=utf-8");//2.获取请求内容StringuserName...

//1.设定编码

request.setCharacterEncoding("utf-8");

response.setCharacterEncoding("utf-8");

response.setContentType("text/html;charset=utf-8");

//2.获取请求内容

String userName = request.getParameter("userName");

String password1 = request.getParameter("password1");

String password2 = request.getParameter("password1");

String email = request.getParameter("password1");

String question = request.getParameter("password1");

String answer = request.getParameter("password1");

PrintWriter out = response.getWriter();

//创建数据库连接

String driver="com.mysql.jdbc.Driver";

String url="jdbc:mysql://127.0.0.1:3306/blog";

String user="root";

String password="";

try

{

Class.forName(driver).newInstance();

Connection con= DriverManager.getConnection(url, user, password);

Statement stmt= con.createStatement();

String sql="insert into username(username,password,email,question,answer) values("+userName+","+password1+","+email+","+question+","+answer+")";

stmt.execute(sql);

out.println("插入成功");

stmt.close();

con.close();

}

catch(Exception e)

{

out.println("操作失败");

e.printStackTrace();

}

这个连接有错误吗？运行时老师显示操作失败，不知道什么问题

怎么进行异常捕获？。。抛出异常？

展开