第七次作业
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>jm</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<form name="form1" method="post" action="control.jsp">
<table>
<td>账号:</td>
<td><input type="text" name="uname" id="userName">
</td>
</tr>
<tr>
<td>登录密码:</td>
<td><input type="password" name="upwd" id="pwd">
</td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="注册">
</td>
<td colspan="2" style=""><input type="submit" value="登录">
</td>
</tr>
</table>
</form>
</body>
</html>
复制代码
zc.jsp
复制代码
<%@ page import="com.bean.pyh.UserBean"%>
<%@ page import="com.dao.pyh.Dao"%>
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
Stu s = new Stu();
int id = Integer.parseInt(request.getParameter("sid"));
s.setUid(id);
String uname = request.getParameter("uname");
s.setUname(uname);
String upwd = request.getParameter("upwd");
s.setUpwd(upwd);
StuDao sd = new StuDao();
if (sd.addStu(s) > 0) {
out.print("注册成功");
} else {
out.print("注册失败");
}
%>
复制代码
stu.java
复制代码
package com.pyh.UserBean;
public class stu {
private int uid;
private String uname;
private String upwd;
public int getUid() {
return uid;
}
public void setUid(int uid) {
this.uid = uid;
}
public String getUname() {
return uname;
}
public void setUname(String uname) {
this.uname = uname;
}
public String getUpwd() {
return upwd;
}
public void setUpwd(String upwd) {
this.upwd = upwd;
}
public Stu(int uid, String uname, String upwd) {
super();
this.uid = uid;
this.uname = uname;
this.upwd = upwd;
}
public Stu() {
super();
}
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
}
}
复制代码
stuDao.java
复制代码
package com.mfb.Dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import com.pyh.bean.Stu;
public class StuDao {
public int addStu(Stu s) {
int i = 0;
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/mysql", "root", "root");
String sql = "insert into stu values(?,?,?)";
PreparedStatement ps = con.prepareStatement(sql);
ps.setString(1, s.getUname());
ps.setString(2, s.getUpwd());
i = ps.executeUpdate();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return i;
}
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
}
}