Java web连数据库的案例

72 阅读 0 评论 48 点赞

我是靠谱客的博主合适眼睛，最近开发中收集的这篇文章主要介绍Java web连数据库的案例，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>

<html>
<body>
<% String driverName="com.mysql.jdbc.Driver";
String userName="root";
String userPwd="123456";
String dbName="login";
String url1="jdbc:mysql://localhost:3306/"+dbName;
String url2="?user="+userName+"&password="+userPwd;
String url3="&useUnicode=true&characterEncoding=UTF-8";
String url=url1+url2+url3;
Class.forName(driverName);
Connection conn=DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String sql="select * from logininfo";
ResultSet rs=stmt.executeQuery(sql);
%>


<%
String name1=request.getParameter("name");
String passwd=request.getParameter("pwd");
while (rs.next()){
if(name1.equals(rs.getString(1)) && passwd.equals(rs.getString(2)))
{ request.getRequestDispatcher("success.jsp").forward(request, response);}
else {
response.sendRedirect("fail.jsp");
}
}
%>


</body>
</html>