第十周jsp
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class BaseDao {
public Connection getConnection() {
Connection con = null;
try {
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","123456");
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
protected void closeAll(Connection con,PreparedStatement ps,ResultSet rs){
try {
if(rs != null)
rs.close();
if(ps != null)
ps.close();
if(con != null)
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
package com.a98.jdbc;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class StuDao extends BaseDao {
public int Register(String uname, String password, int age) {
int i = -1;
Connection con = getConnection();
String sql = "insert into stu(uname,password,age)values(?,?,?)";
PreparedStatement pred = null;
try {
pred = con.prepareStatement(sql);
pred.setString(1, uname);
pred.setString(2, password);
pred.setInt(3, age);
i = pred.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
closeAll(con, pred, null);
}
return i;
}
public boolean Login(String uname, String password) {
boolean f=false;
Connection con = getConnection();
String sql = "select * from stu where uname=? and password=?";
PreparedStatement pred = null;
ResultSet resultSet = null;
try {
pred = con.prepareStatement(sql);
pred.setString(1, uname);
pred.setString(2, password);
resultSet = pred.executeQuery();
while (resultSet.next()) {
f=true;
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
closeAll(con, pred, resultSet);
}
return f;
}
}
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
%>
<!
DOCTYPE
HTML>
<
html
>
<
head
>
<
title
>注册</
title
>
</
head
>
<
body
>
<
h1
>注册</
h1
>
<
form
action="doregister.jsp" method="post">
<
table
>
<
tr
>
<
td
>用户名</
td
>
<
td
><
input
type="text" name="uname"></
td
>
</
tr
>
<
tr
>
<
td
>密码</
td
>
<
td
><
input
type="password" name="password"></
td
>
</
tr
>
<
tr
>
<
td
>年龄</
td
>
<
td
><
input
type="number" name="age"></
td
>
</
tr
>
<
tr
>
<
td
><
input
type="submit" value="注册"></
td
>
<
td
><
input
type="reset" value="重置"></
td
>
</
tr
>
</
table
>
</
form
>
</
body
>
</
html
>
<%@page import="com.a98.jdbc.StuDao"%>
<%@page import="javax.xml.bind.ParseConversionEvent"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
%>
<!
DOCTYPE
HTML>
<
html
>
<
head
>
<
title
></
title
>
</
head
>
<
body
>
<%
String uname = request.getParameter("uname");
String password = request.getParameter("password");
String age = request.getParameter("age");
int age1 = age == null ? -1 : Integer.parseInt(age);
StuDao sd=new StuDao();
int i=sd.Register(uname, password, age1);
if(i>0){
request.getRequestDispatcher("login.jsp").forward(request, response);
}else{
out.print("注册失败");
}
%>
</
body
>
</
html
>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
%>
<!
DOCTYPE
HTML>
<
html
>
<
head
>
<
title
>登录</
title
>
</
head
>
<
body
>
<
h1
>欢迎</
h1
>
<
form
action="dologin.jsp" method="post">
<
table
>
<
tr
>
<
td
>用户名</
td
>
<
td
><
input
type="text" name="uname"></
td
>
</
tr
>
<
tr
>
<
td
>密码</
td
>
<
td
><
input
type="password" name="password"></
td
>
</
tr
>
<
tr
>
<
td
><
input
type="submit" value="登录"></
td
>
<
td
><
a
href="register.jsp">注册</
a
></
td
>
</
tr
>
</
table
>
</
form
>
</
body
>
</
html
>
<%@page import="com.a98.jdbc.StuDao"%>
<%@page import="javax.xml.bind.ParseConversionEvent"%>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
%>
<!
DOCTYPE
HTML>
<
html
>
<
head
>
<
title
></
title
>
</
head
>
<
body
>
<%
String uname = request.getParameter("uname");
String password = request.getParameter("password");
StuDao sd=new StuDao();
if(sd.Login(uname, password)){
request.getRequestDispatcher("index1.jsp").forward(request, response);
}else{
out.print("登陆失败,即将跳回登陆页.....");
response.setHeader("refresh", "2;url=login.jsp");
}
%>
</
body
>
</
html
>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");%>
<!
DOCTYPE
HTML>
<
html
>
<
head
>
<
title
></
title
>
</
head
>
<
body
>
<
h1
>登录成功</
h1
>
</
body
>
</
html
>