jsp连接mysql异常,求大神指点
蒲公草 2016-09-07 10:23:41 <%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ page import="java.util.*,java.text.*" %>
<%@ page import="javax.sql.*,javax.naming.*,webbook.util.*" %>
<%@ page import="java.sql.*,com.mysql.jdbc.Driver" %>
<% String context=request.getContextPath(); %>
<html>
<head>
<title>guestbook</title>
</head>
<body>
String driverName="com.mysql.jdbc.Driver";
String url = "jdbc:mysql://127.0.0.1:8080/test?useUnicode=true&characterEncoding=UTF-8";
String username = "root";
String password = "xiaopu123";
String sql="insert into guestbook(id,name,email,phone,title,content,time) values (gb_seq.nextval,?,?,?,?,?,?)";
int result=0;
Connection conn=null;
request.setCharacterEncoding("utf-8");
String name = request.getParameter("name");
String title = request.getParameter("title");
try{
Class.forName(driverName);
conn=DriverManager.getConnection(url,username,password);
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, StringUtil.filterHtml(name));
pstmt.setString(2, request.getParameter(request.getParameter("email")));
pstmt.setString(3, request.getParameter(request.getParameter("phone")));
pstmt.setString(4, StringUtil.filterHtml(title));
pstmt.setString(5, request.getParameter("content"));
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-ddhh:mm:ss");
pstmt.setString(6, sdf.format(new java.util.Date()));
result = pstmt.executeUpdate();
pstmt.close();
}catch (ClassNotFoundException e){
e.printStackTrace();
out.println("!");
}catch(SQLException e){
e.printStackTrace();
out.println("无法连接数据库,请检查数据库连接是否正确!");
}
if(result==0){
out.println("对不起,添加留言不成功,请您重新输入!<br>");
out.println("<a href=\""+context+"/addMessage.jsp\">添加新的留言内容</a><br>");
}else{
out.println("祝贺您,成功添加留言。<br>");
out.println("<a href=\""+context+"/getMessages.jsp\">查看所有留言内容</a><br>");
}
%>
<br>
<p align="center">
Copyright © 2016 <a href="http://www.baidu.com">baidu.com</a>
</body>
</html>
错误信息:com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
PS:mysql-connector-java.jar包已经放在lib目录下,classpath也配置好了,求大神指点啊啊啊啊啊啊啊