SEVERLET(服务器):
packageJava_web.Java_web0;importjava.io.IOException;//import java.io.PrintWriter;//import java.sql.Connection;//import java.sql.ResultSet;
importjava.sql.SQLException;//import java.sql.Statement;
importjavax.servlet.ServletException;//import javax.servlet.ServletRequest;//import javax.servlet.ServletResponse;
importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importJava_web.Java_web1.Dbbase;public class servlet0 extendsHttpServlet{/****/
private static final long serialVersionUID = 1L;/*法1:
* private static final long serialVersionUID = 1L;
@Override
public void service(ServletRequest req, ServletResponse res) throws ServletException, IOException
{
// TODO Auto-generated method stub
req.setCharacterEncoding("utf-8");
res.setContentType("text/html;charset=utf-8");
PrintWriter print=res.getWriter();
String psword=req.getParameter("psword");
String Name=req.getParameter("Name");
//调用方法
Dbbase db = new Dbbase();
Connection con = null ;
try {
con=db.communicate();
} catch (ClassNotFoundException | SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Statement seach=null;
try {
seach=(Statement)con.createStatement();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String sql="select * from table0 where username='"+Name+"'and password='"+psword+"'";
ResultSet result = null;
try {
result=seach.executeQuery(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
if(result.next())
{
print.println("
前端与数据库交互");print.println("
姓名:"+Name+"
密码:"+psword+"
print.close();
}
else
{
print.println("
前端与数据库交互");print.println("
print.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}*/
//法2:
@Overrideprotected void doPost(HttpServletRequest req, HttpServletResponse resp) throwsServletException, IOException {//TODO Auto-generated method stub
req.setCharacterEncoding("utf-8");
resp.setContentType("text/html;charset=utf-8");
String Name=req.getParameter("Name");
String psword=req.getParameter("psword");
Dbbase db=newDbbase();boolean flag=false;try{
flag=db.test(Name,psword);
}catch (ClassNotFoundException |SQLException e) {//TODO Auto-generated catch block
e.printStackTrace();
}if(flag)
{//如果前端传递的参数存在,就转发到后台主页面//转发
req.getRequestDispatcher("main.jsp").forward(req, resp);
}else{//如果不存在,重新回到登录页面//重定向
resp.sendRedirect("0.jsp");//打开新0.jsp页面,是重新定向,前后页面不是一个request。//req.getRequestDispatcher("0.jsp").forward(req, resp);//刷新页面,是请求转发,前后页面共享一个request ;
}
}
}