这里一共有两个程序,一个是用户的登录界面,一个是现实结果的页面
用户登录界面:,先谢谢了。
-------------------------------------------------------------------------------
<%@ page contentType="text/html;charset=gbk" pageEncoding="gbk"%>
<%@ page language="java" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>数据库测试!</title>
</head>
<body>
<center>
<font size = 5 color = blue>用户登录界面<font>
</center>
<form action="Add.jsp" method="post" >
用户名:<input type="text" name="name" ><br>
密码 : <input type="text" name="password"> <br>
添加: <input type="submit" value="添加数据">
</form>
<br>
</body>
</html>
---------------------------------------------------------------
数据的处理界面如下:
——————————————————————————————————————<%@ page contentType="text/html;charset=utf-8"%>
<%@ page language="java"%>
<%@ page import="java.sql.*"%><html>
<head> <title>添加数据</title> </head> <body>
<%
String userName = request.getParameter("name");
String userPassword = request.getParameter("password");
if (userName.equals("") && userPassword.equals("")) {
out.println("用户名和密码都没有输入!!");
} else if (userPassword.equals("")) {
out.println("没有输入密码!");
} else if (userName.equals("")) {
out.println("没有输入用户名!");
} else {
out.println("输出接受过来的值");
out.println(userName);
out.println(userPassword) ;
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/student";
Connection conn = DriverManager.getConnection (url, "zhaobo", "123");
Statement stmt =conn.createStatement();
int ps= Integer.parseInt(userPassword);
String s = "insert into student values('userName','ps')";
stmt.executeUpdate(s);
ResultSet rs = stmt.executeQuery("select * from student ");
while(rs.next()){
out.print(rs.getString("userName")+"\t");
out.print(rs.getString("password")+"\t");
out.println();
}
conn.close();
stmt.close();
rs.close();
}
%>
</body>
</html>
用户登录界面:,先谢谢了。
-------------------------------------------------------------------------------
<%@ page contentType="text/html;charset=gbk" pageEncoding="gbk"%>
<%@ page language="java" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>数据库测试!</title>
</head>
<body>
<center>
<font size = 5 color = blue>用户登录界面<font>
</center>
<form action="Add.jsp" method="post" >
用户名:<input type="text" name="name" ><br>
密码 : <input type="text" name="password"> <br>
添加: <input type="submit" value="添加数据">
</form>
<br>
</body>
</html>
---------------------------------------------------------------
数据的处理界面如下:
——————————————————————————————————————<%@ page contentType="text/html;charset=utf-8"%>
<%@ page language="java"%>
<%@ page import="java.sql.*"%><html>
<head> <title>添加数据</title> </head> <body>
<%
String userName = request.getParameter("name");
String userPassword = request.getParameter("password");
if (userName.equals("") && userPassword.equals("")) {
out.println("用户名和密码都没有输入!!");
} else if (userPassword.equals("")) {
out.println("没有输入密码!");
} else if (userName.equals("")) {
out.println("没有输入用户名!");
} else {
out.println("输出接受过来的值");
out.println(userName);
out.println(userPassword) ;
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/student";
Connection conn = DriverManager.getConnection (url, "zhaobo", "123");
Statement stmt =conn.createStatement();
int ps= Integer.parseInt(userPassword);
String s = "insert into student values('userName','ps')";
stmt.executeUpdate(s);
ResultSet rs = stmt.executeQuery("select * from student ");
while(rs.next()){
out.print(rs.getString("userName")+"\t");
out.print(rs.getString("password")+"\t");
out.println();
}
conn.close();
stmt.close();
rs.close();
}
%>
</body>
</html>
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.Add_jsp._jspService(Add_jsp.java:105)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
String s = "insert into student values('userName','ps')";
String s = "insert into student values('" + userName + "','" + ps + "')";
密码为什么只能是数字呢?