jsp+jdbc+sql 的作业有简单的登录注册就可以了
2个回答
展开全部
先写java方法：
/**
* 用户登录
*/
public boolean customerLogin(String customername, String customerpass) {
String sql="select * from customer where c_name = ? and c_pass = ? ";
if(jdbcTemplate.query(sql, new CustomerRowMapper(),customername,customerpass).size()==1){
return true;
}
return false;
}
/**
* 用户注册
*
*/
public int customerAdd(String customername, String customerpass1, String customerpass2, String customertel){
if (customerpass1.equals(customerpass2)) {
List<Customer> list=this.showCustomer();
for(Customer customer:list){
if(customer.getCname().equals(customername)|| customer.getCtel().equals(customertel)){
return 0;
}
}
if(customername.length()>8){
return -2;
}
if(customername==""){
return -3;
}
String sql = "insert into customer (c_name,c_pass,c_tel) values(?,?,?)";
return jdbcTemplate.update(sql, customername, customerpass1, customertel);
}
return -1;
}
再写action：
/**
* 用户注册
*
*/
public int customerAdd(String customername, String customerpass1, String customerpass2, String customertel){
if (customerpass1.equals(customerpass2)) {
List<Customer> list=this.showCustomer();
for(Customer customer:list){
if(customer.getCname().equals(customername)|| customer.getCtel().equals(customertel)){
return 0;
}
}
if(customername.length()>8){
return -2;
}
if(customername==""){
return -3;
}
String sql = "insert into customer (c_name,c_pass,c_tel) values(?,?,?)";
return jdbcTemplate.update(sql, customername, customerpass1, customertel);
}
return -1;
}
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
this.doGet(request,response);
}
最后写jsp页面：
longin.jsp
<body>
<form action="CustomerAction?action=denglu" method="post">
<table width="1000" border="0" align="center" bgcolor="#FFFFFF">
<tr>
<td align="left" valign="middle"><span class="STYLE2">当前位置：首页>登录页面</span></td>
</tr>
<tr><td> </td></tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle"><span class="STYLE1">用户名： <input type="text" name="customername"></span></td>
</tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle"><span class="STYLE1">密码： <input type="password" name="customerpass"></span></td>
</tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle"><input type="image" src="bg_image/an2.jpg" alt="Submit" ></td>
</tr>
<tr><td> </td></tr>
</table>
</form>
</body>
loginReg.jsp
<form method="post" action="CustomerAction?action=zhuce">
<table width="1000" border="0" align="center" bgcolor="#FFFFFF">
<tr>
<td align="left" valign="middle"><span class="STYLE2">当前位置：首页>注册页面</span></td>
</tr>
<tr><td> </td></tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle"><span class="STYLE1">用户名： <input type="text" name="customername"></span></td>
</tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle"><span class="STYLE1">密码： <input type="password" name="customerpass1"></span></td>
</tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle"><span class="STYLE1">重复密码：<input type="password" name="customerpass2"></span></td>
</tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle"><span class="STYLE1">手机号码：<input type="text" name="customeremail"></span></td>
</tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle">
<label>
<input type="checkbox" name="checkbox" value="checkbox" />
</label>
<span class="STYLE1">我已经仔细阅读并且同意《会员协议》</span>
</td>
</tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle"><input type="image" src="bg_image/an1.jpg" alt="Submit" ></td>
</tr>
<tr><td> </td></tr>
</table>
</form>
</body>
/**
* 用户登录
*/
public boolean customerLogin(String customername, String customerpass) {
String sql="select * from customer where c_name = ? and c_pass = ? ";
if(jdbcTemplate.query(sql, new CustomerRowMapper(),customername,customerpass).size()==1){
return true;
}
return false;
}
/**
* 用户注册
*
*/
public int customerAdd(String customername, String customerpass1, String customerpass2, String customertel){
if (customerpass1.equals(customerpass2)) {
List<Customer> list=this.showCustomer();
for(Customer customer:list){
if(customer.getCname().equals(customername)|| customer.getCtel().equals(customertel)){
return 0;
}
}
if(customername.length()>8){
return -2;
}
if(customername==""){
return -3;
}
String sql = "insert into customer (c_name,c_pass,c_tel) values(?,?,?)";
return jdbcTemplate.update(sql, customername, customerpass1, customertel);
}
return -1;
}
再写action：
/**
* 用户注册
*
*/
public int customerAdd(String customername, String customerpass1, String customerpass2, String customertel){
if (customerpass1.equals(customerpass2)) {
List<Customer> list=this.showCustomer();
for(Customer customer:list){
if(customer.getCname().equals(customername)|| customer.getCtel().equals(customertel)){
return 0;
}
}
if(customername.length()>8){
return -2;
}
if(customername==""){
return -3;
}
String sql = "insert into customer (c_name,c_pass,c_tel) values(?,?,?)";
return jdbcTemplate.update(sql, customername, customerpass1, customertel);
}
return -1;
}
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
this.doGet(request,response);
}
最后写jsp页面：
longin.jsp
<body>
<form action="CustomerAction?action=denglu" method="post">
<table width="1000" border="0" align="center" bgcolor="#FFFFFF">
<tr>
<td align="left" valign="middle"><span class="STYLE2">当前位置：首页>登录页面</span></td>
</tr>
<tr><td> </td></tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle"><span class="STYLE1">用户名： <input type="text" name="customername"></span></td>
</tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle"><span class="STYLE1">密码： <input type="password" name="customerpass"></span></td>
</tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle"><input type="image" src="bg_image/an2.jpg" alt="Submit" ></td>
</tr>
<tr><td> </td></tr>
</table>
</form>
</body>
loginReg.jsp
<form method="post" action="CustomerAction?action=zhuce">
<table width="1000" border="0" align="center" bgcolor="#FFFFFF">
<tr>
<td align="left" valign="middle"><span class="STYLE2">当前位置：首页>注册页面</span></td>
</tr>
<tr><td> </td></tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle"><span class="STYLE1">用户名： <input type="text" name="customername"></span></td>
</tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle"><span class="STYLE1">密码： <input type="password" name="customerpass1"></span></td>
</tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle"><span class="STYLE1">重复密码：<input type="password" name="customerpass2"></span></td>
</tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle"><span class="STYLE1">手机号码：<input type="text" name="customeremail"></span></td>
</tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle">
<label>
<input type="checkbox" name="checkbox" value="checkbox" />
</label>
<span class="STYLE1">我已经仔细阅读并且同意《会员协议》</span>
</td>
</tr>
<tr><td> </td></tr>
<tr>
<td align="center" valign="middle"><input type="image" src="bg_image/an1.jpg" alt="Submit" ></td>
</tr>
<tr><td> </td></tr>
</table>
</form>
</body>
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
