servlet 连接数据库 通过html,用servlet做用户登录框，通过sql数据库验证成功后进录博客界面...

//1，用户登录界面

package com.mjrj;

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;

public class login extends HttpServlet {

public void doGet(HttpServletRequest request,

HttpServletResponse response)

throws

ServletException, IOException {

response.setContentType("text/html;charset=gbk");

PrintWriter out =

response.getWriter();

out.println("");

out.println(" 

用户登陆");

out.println(" 

");

out.println("

用户登录

");

out.println("

action=loginCL method=post>");

out.println("用户名:

type=text

name=username>
");

out.println("密码:

type=password

name=passwd>
");

out.println("

type=submit value=登陆>");

out.println("

type=reset value=重置>");

out.println("

");

out.println("");

out.flush();

out.close();

}

public void doPost(HttpServletRequest request,

HttpServletResponse response)

throws

ServletException, IOException {

this.doGet(request,

response);

}

}

//2,通过连接sql数据库进行验证

package com.mjrj;

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.*;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

public class loginCL extends HttpServlet {

private static final String String =

null;

ResultSet rt = null;

Statement stmt = null;

Connection conn = null;

public void doGet(HttpServletRequest request,

HttpServletResponse response)

throws

ServletException, IOException {

try{ response.setContentType("text/html;charset=gbk");

PrintWriter out =

response.getWriter();

//获取用户名和密码

String usern =

request.getParameter("username");

String passw =

request.getParameter("passwd");

//session

HttpSession

hs=request.getSession(true);

//链接数据库

Class.forName("com.mysql.jdbc.Driver");

Connection conn =

DriverManager.getConnection("jdbc:mysql://localhost:3306/blog",

"root","123");

stmt =

conn.createStatement();

//验证用户名和密码是否一致

rt = stmt.executeQuery("select

username,`password` from user where username='"+usern+"' and

password='"+passw+"' ");

if(rt.next()){

response.sendRedirect("blog_html/boke2.html");

hs.setAttribute("username", usern);

hs.setAttribute("password",passw);

}

else{response.sendRedirect("login");}

}catch(ClassNotFoundException e){

e.printStackTrace();

}catch(SQLException e ){

e.printStackTrace();

}

}

public void doPost(HttpServletRequest request,

HttpServletResponse response)

throws

ServletException, IOException {

this.doGet(request,

response);

}

public void init() throws ServletException

{

// Put your code here

}

}

注:在servlet里连接数据库要对web.xml进行配置,配置内容

driverClass

com.mysql.jdbc.Driver

url

jdbc:mysql://localhost:3306/blog

user

root

password

123