- </body>
- </html>
- success.jsp
- <%@ page language="java" contentType="text/html; charset=utf-8"
- pageEncoding="utf-8"%>
- <!DOCTYPE html PUBLIC "-//W3C//DTD HTM1 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
- <title>Insert title here</title>
- </head>
- <body>
登录成功
- </body>
- </html>
- fail.jsp
- <%@ page language="java" contentType="text/html; charset=utf-8"
- pageEncoding="utf-8"%>
- <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
- <title>Insert title here</title>
- </head>
- <body>
登录失败
</body>
</html>
核心处理界面
- chuli.jsp
- <%@page import="java.sql.DriverManager"%>
- <%@page import="java.sql.ResultSet"%>
- <%@page import="java.sql.PreparedStatement"%>
- <%@page import="java.sql.Connection"%>
- <%@ page language="java" contentType="text/html; charset=utf-8"
- pageEncoding="utf-8"%>
- <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
- <title>Insert title here</title>
- </head>
- <body>
- <!-- 获取登录信息 -->
- <% String uname=request.getParameter("uname");
- String pwd=request.getParameter("pwd"); %>
- <%
- try{
- Class.forName("oracle.jdbc.driver.OracleDriver");
- String url="jdbc:oracle:thin:@192.168.0.248:1521:orcl";
- Connection conn = DriverManager.getConnection(url, "ms_test", "1");
- String sql="select * from test where uname=?and pwd=?";
- PreparedStatement ps=conn.prepareStatement(sql);
- ps.setString(1, uname);
- ps.setString(2, pwd);
- ResultSet re=ps.executeQuery();
- if(re.next()){
- %>
- <jsp:forward page="success.jsp"></jsp:forward>
- <%
- }else{
- %>
- <jsp:forward page="fail.jsp"></jsp:forward>
- <%
- }
- }catch(Exception e){
- e.printStackTrace();
- }
- %>
- </body>
- </html>
总结: 驱动包存放目录问题, 驱动包可以在 Oracle 安装目录下查找 action="" 处理问题, 编码问题.
三: JSP 简易注册
需要 3 个 jsp 文件
1. 注册 zhuce.jsp
2. 注册成功 success1.jsp
3. 注册失败 fail1.jsp
4. 事务处理核心 chuli2.jsp
如下:
注册 zhuce.jsp
- <%@ page language="java" contentType="text/html; charset=utf-8"
- pageEncoding="utf-8"%>
- <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
- <title>Insert title here</title>
- </head>
- <body>
- <form action="chuli2.jsp" method="post">// 核心处理事务 jsp
- <table align="center">
- <tr>
- <td > 账号:</td>
- <td><input type="text" name="uname"></td>
- </tr>
- <tr>
- <td > 密码:</td>
- <td><input type="password" name="pwd"></td>
- </tr>
- <tr>
- <td><input type="submit" value="注册"></td>
- <td><input type="reset" value="重置"></td>
- <td><a href="login.jsp"> 返回登录 </a></td>
- </tr>
- </table>
- </form>
- </body>
- </html>
- chuli2.jsp
- <%@page import="java.sql.DriverManager"%>
- <%@page import="java.sql.ResultSet"%>
- <%@page import="java.sql.PreparedStatement"%>
- <%@page import="java.sql.Connection"%>
- <%@ page language="java" contentType="text/html; charset=utf-8"
- pageEncoding="utf-8"%>
- <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
- <title>Insert title here</title>
- </head>
- <body>
- <!-- 获取注册信息 -->
- <% String uname=request.getParameter("uname");
- String pwd=request.getParameter("pwd"); %>
- <%
- try{
- Class.forName("oracle.jdbc.driver.OracleDriver");
- String url="jdbc:oracle:thin:@192.168.0.248:1521:orcl";
- Connection conn = DriverManager.getConnection(url, "ms_test", "1");
- String sql="insert into test values (?,?)";//insert into 信息插入数据库
- PreparedStatement ps=conn.prepareStatement(sql);
- ps.setString(1, uname);
- ps.setString(2, pwd);
- if(ps.executeUpdate()>-1){// 对应的为 update
- %>
- <jsp:forward page="success1.jsp"></jsp:forward>
- <%
- }else{
- %>
- <jsp:forward page="fail1.jsp"></jsp:forward>
- <%
- }
- }catch(Exception e){
- e.printStackTrace();
- }
- %>
- </body>
- </html>
- success1.jsp
- <%@ page language="java" contentType="text/html; charset=utf-8"
- pageEncoding="utf-8"%>
- <!DOCTYPE html PUBLIC "-//W3C//DTD HTM1 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
- <title>Insert title here</title>
- </head>
- <body>
- 注册成功 < a href="login.jsp"> 登录 </a>// 注册成功则点击登录跳转登录页面
- </body>
- </html>
- fail1.jsp
- <%@ page language="java" contentType="text/html; charset=utf-8"
- pageEncoding="utf-8"%>
- <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
- <title>Insert title here</title>
- </head>
- <body>
- 注册失败 < a href="zhuce.jsp"> 再次注册 </a>
- </body>
- </html>
来源: http://www.bubuko.com/infodetail-2667695.html