JSP和JDBC代码汇总

import java.io.IOException;
import java.sql.*;

public class JDBCUtils {

private static String driver="com.mysql.jdbc.Driver";
private static String url="jdbc:mysql://localhost:3306/java_web";
private static String username="root";
private static String password="root";

/*获取连接*/
public static Connection getConnection() {
    Connection connection = null;
    try {
        Class.forName(driver);
        connection = DriverManager.getConnection(url,username,password);
    } catch (ClassNotFoundException e) {
        e.printStackTrace();
    } catch (SQLException e) {
        e.printStackTrace();
    }
    return connection;
}

/*关闭资源*/
public static void release(Connection connection, PreparedStatement preparedStatement, ResultSet resultSet) {

    if(resultSet!=null) {
        try {
            resultSet.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    if(preparedStatement!=null) {
        try {
            preparedStatement.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    if(connection!=null) {
        try {
            connection.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

}

public class TestConnection{
public static void main(String[] args) {
Connection conn=JDBCUtils.getConnection();
if(conn !=null){
System.out.println(“数据库接创建成功!”);
}
}
}

//查询表中的所有数据
public class JDBCQuery{
public static void main(String[] args) {
Connection conn=JDBCUtils.getConnection();
if(conn !=null){
System.out.println(“数据库接创建成功!”);

	  Statement stmt = conn.createStatement();
      String sql = "SELECT * FROM web_user";
      ResultSet rs = stmt.executeQuery(sql);
	  //在控制台打印查询结果
	  while(rs.next()){
           int id  = rs.getInt("id");
           String name = rs.getString("name");
           String pass = rs.getString("password");
		   String email = rs.getString("email");

           System.out.print("ID: " + id);
           System.out.print(", name: " + name);
           System.out.print(", password: " + pass);
		   System.out.print(", email: " + email);
           System.out.print("\n");
       }
	}else{
	    System.out.println("数据库接失败!");
	}
}

}

login.jsp 代码：
<%@ page language=“java” import=“java.util.*” pageEncoding=“UTF-8”%>

if(form.username.value == “”) {
alert(“用户名不能为空!”);
return false;
}
if(form.password.value == “”) {
alert(“密码不能为空!”);
return false;
}else if(form.password.value.length<6){
alert(“密码不能少于6位!”);
return false;
}
return true;
}

用户登录

用户名
密码

doLogin.jsp 代码：

<%@ page language=“java” import=“java.util.*” pageEncoding=“UTF-8”%>

<%

request.setCharacterEncoding(“utf-8”);
response.setContentType(“text/html;charset=utf-8”);

String name=request.getParameter(“username”);
String password=request.getParameter(“password”);
//判断登陆界面的用户名和密码，根据输入的不同情况进行不同的处理
if(name.trim().equals(“admin”)&&password.trim().equals(“111111”))
{
out.print(“登陆成功”);
}
else{
out.print(“登陆失败”);
}
%>