Java 使用jsp页面利用JDBC访问MySQL数据库简单实现用户登录注册

最新推荐文章于 2021-11-01 19:15:04 发布

VIP文章萌妹子哦哦

最新推荐文章于 2021-11-01 19:15:04 发布

阅读量8.8k

点赞数 7

分类专栏： Java项目文章标签： MySQL JDBC jsp

本文链接：https://blog.csdn.net/bancroft_boy/article/details/81228547

版权

文件列表

test.java--JDBC访问数据库类

package cn.com.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class test {
	public test() {
		// TODO Auto-generated constructor stub
	}

	public static Connection getConnection() throws SQLException,
			ClassNotFoundException {
		Class.forName("com.mysql.jdbc.Driver");
		String url = "jdbc:mysql:///test?useSSL=true";
		return DriverManager.getConnection(url, "root", "root");

	}

	public boolean executeDML(String sql, Object[] args) throws SQLException,
			ClassNotFoundException {
		Connection conn = getConnection();
		PreparedStatement pstmt = conn.prepareStatement(sql);
		pstmt.setObject(1, args[0]);
		pstmt.setObject(2, args[1]);
		ResultSet rs = pstmt.executeQuery();
		if (rs.next()) {
			return true;
		} else {
			return false;
		}
	}

	public boolean executeREG(String sql, Object[] args) throws SQLException,
			ClassNotFoundException {
		Connection conn = getConnection();
		PreparedStatement pstmt = conn.prepareStatement(sql);
		pstmt.setObject(1, args[0]);
		pstmt.setObject(2, args[1]);
		pstmt.setObject(3, args[2]);
		pstmt.setObject(4, args[3]);
		int rs = pstmt.executeUpdate();
		if (rs > 0) {
			return true;
		} else {
			return false;
		}

	}
}

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>登录</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0&

最低0.47元/天解锁文章

萌妹子哦哦

关注

7
点赞
踩
95

收藏

觉得还不错? 一键收藏
2
评论
Java 使用jsp页面利用JDBC访问MySQL数据库简单实现用户登录注册

文件列表test.java--JDBC访问数据库类package cn.com.test;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLExcept...
复制链接

扫一扫