package org.yv;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.yv.util.DBUtil;
public class Login extends HttpServlet {
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//1.:首先要把编码全部改为utf-8
request.setCharacterEncoding("utf-8");
//响应
request.setCharacterEncoding("utf-8");
//显示格式
response.setContentType("textml");
//处理请求
String name = request.getParameter("name");
String pwd = request.getParameter("pwd");
boolean isTrue = false;
/bc
Connection conn =DBUtil.getconn();
String sql = "select * from student";
PreparedStatement ps =null;
try{
ps = conn.prepareStatement(sql);
ps.setString(1, name);
ps.setString(3, pwd);
int count = ps.executeUpdate();
if(count>0){
isTrue = true;
}else{
isTrue = false;
}
}catch(SQLException e){
e.printStackTrace();
}
PrintWriter out = response.getWriter();
out
.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
if(isTrue){
out.println("<h1 style='color:green'>登录成功</h1>");
}else{
out.println("<h1 style='color:red'>登录失败</h1>");
}
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
private void prepareStatement(String sql) {
// TODO Auto-generated method stub
}
}
以上是登录代码
package org.ming;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.ming.util.DBUtil;
public class Login extends HttpServlet {
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
//1.:首先要把编码全部改为utf-8
request.setCharacterEncoding("utf-8");
//响应
request.setCharacterEncoding("utf-8");
//显示格式
response.setContentType("text/html");
//处理请求
String name = request.getParameter("name");
String pwd = request.getParameter("pwd");
String userName = request.getParameter("userName");
String ageStr = request.getParameter("age");
Integer age = Integer.parseInt(ageStr);
boolean isTrue = false;
//jdbc
Connection conn =DBUtil.getconn();
String sql = "insert into users (name,age,pwd,user_name) values (?,?,?,?)";
PreparedStatement ps =null;
try{
ps = conn.prepareStatement(sql);
ps.setString(1, name);
ps.setInt(2,age);
ps.setString(3, pwd);
ps.setString(4, userName);
int count = ps.executeUpdate();
if(count>0){
isTrue = true;
}else{
isTrue = false;
}
}catch(SQLException e){
e.printStackTrace();
}
PrintWriter out = response.getWriter();
out
.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
out.println("<HTML>");
out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
out.println(" <BODY>");
if(isTrue){
out.println("<h1 style='color:green'>注册成功</h1>");
}else{
out.println("<h1 style='color:red'>注册失败</h1>");
}
out.println(" </BODY>");
out.println("</HTML>");
out.flush();
out.close();
}
private void prepareStatement(String sql) {
// TODO Auto-generated method stub
}
}
以上是注册