org.apache.jasper.JasperException: Exception in JSP: /javascript/zhuce_insert.jsp:107: String driverName = "com.mysql.jdbc.Driver";
8: String url = "jdbc:mysql://localhost:3306/stu_inform";
9: Class.forName("com.mysql.jdbc.Driver");
10: Connection conn = DriverManager.getConnection(url,"root","");
11: Statement statement = conn.createStatement();
12: String sql = "insert into stu_record values(" + request.getParameter("stuname") + "," + Integer.parseInt(request.getParameter("stunum")) + "," + request.getParameter("stuem") + ")";
13: statement.executeUpdate("sql");
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)我的mysql已经启动,tomcat也已经启动,我不知道数据库的用户名和密码,不知道再哪看。反正进去就能用的,本来用户名和密码那我都填空的,但是不行,后来就加个root用户名上去了。
我将 mysql-connector-java-3.1.0-alpha-bin.jar
复制到了我的/tomcat/webapps/ROOT/WEB-INF/lib下了,不知道还需要什么配置没??请大家帮帮我,谢谢!!
8: String url = "jdbc:mysql://localhost:3306/stu_inform";
9: Class.forName("com.mysql.jdbc.Driver");
10: Connection conn = DriverManager.getConnection(url,"root","");
11: Statement statement = conn.createStatement();
12: String sql = "insert into stu_record values(" + request.getParameter("stuname") + "," + Integer.parseInt(request.getParameter("stunum")) + "," + request.getParameter("stuem") + ")";
13: statement.executeUpdate("sql");
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)我的mysql已经启动,tomcat也已经启动,我不知道数据库的用户名和密码,不知道再哪看。反正进去就能用的,本来用户名和密码那我都填空的,但是不行,后来就加个root用户名上去了。
我将 mysql-connector-java-3.1.0-alpha-bin.jar
复制到了我的/tomcat/webapps/ROOT/WEB-INF/lib下了,不知道还需要什么配置没??请大家帮帮我,谢谢!!
解决方案 »
- 关于java调用dll再问,两贴共200分。
- Cannot create JDBC driver of class '' for connect URL 'null'
- 请教,jsp只取得由javabean返回的一个Vector,读取此vector发生了死循环?
- 想知道oracle,mssql这些收费的数据库到底要多少钱?
- 求助:网页高手帮忙啊
- jbuilder 2005的问题
- 写html中applet标记codebase的问题
- 用JXL包读出了Excel文件的内容了,如何放到数据库???
- 如何取得jsp网站的本地安装的目录?
- fastjson返回的json数据的解析
- eclipse外无法启动tomcat
- 上传限制大小,出提示框后,如何保留上传文件路径
import java.sql.*;public class Connector{private String url="jdbc:mysql://localhost:3306/stu_inform";
private String driver="com.mysql.jdbc.Driver";
private String user="root";
private String pw="";public static Connection getConnection()throws SQLException{Class.forName(driver);
Connection conn=DriverManager.getConnection(url,user,pw);return conn;
}}
应该是你的密码不对,在安装mysql 时,应该是有密码的!不行你就在CMD中,先把路径切换到你的数据库目录:
如c:/program files/Mysql/mysql server 5.2
然后敲入
mysql -uroot -p会提示你输入密码,你可以在这试一下密码!
C:/program files/mysql/mysql server 5.2/bin一定要到bin 下!