jsp访问数据库
只需要一个jsp文件就可以了,先得有数据库,我这里用的是mysql 8.0 和Navicat 15,Tomcat 9.0.30
先得建一个简单的表
<%@ page contentType="text/html;charset=UTF-8" language="java" import="java.sql.*" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<%
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/aaa?characterEncoding=utf8&serverTimezone=GMT%2B8","root","123456");
Statement stat =conn.createStatement();
String sql =
"SELECT STUNO,STUNAME FROM T_STUDENT WHERE STUSEX='女'";
ResultSet rs=stat.executeQuery(sql);
while(rs.next()){
String stuno=rs.getString("STUNO");
String stuname=rs.getString("STUNAME");
out.println(stuno +""+stuname +"<br>");
}
stat.close();
conn.close();
%>
</body>
</html>
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/aaa?characterEncoding=utf8&serverTimezone=GMT%2B8","root","123456");
这里的账户和密码是你自己当时设置的,记得改成你自己的
这个jsp文件是查询女生功能,显示表中女生的数据,
再来一个简单的表单存数据吧
先看效果
下面这个是insertForm.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<form action="insert3.jsp"method ="post">
输入学号:<input type="text"name="stuno"><br>
输入姓名:<input type="text"name="stuname"><br>
选择性别:
<select name="stusex">
<option value="男">男</option>
<option value="女">女</option>
</select><br>
<input type="submit"value="提交">
</form>
</body>
</html>
下面这个是insert3.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" import="java.sql.*" %>
<html>
<head>
<title>Title</title>
</head>
<body>
<%
request.setCharacterEncoding("UTF-8");
String stuno=request.getParameter("stuno");
String stuname=request.getParameter("stuname");
String stusex=request.getParameter("stusex");
Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/aaa?characterEncoding=utf8&serverTimezone=GMT%2B8","root","123456");
String sql = "INSERT INTO T_STUDENT(STUNO,STUNAME,STUSEX)VALUES(?,?,?)";
PreparedStatement ps =conn.prepareStatement(sql);
ps.setString(1,stuno);
ps.setString(2,stuname);
ps.setString(3,stusex);
int i=ps.executeUpdate();
out.println(" 成功添加"+ i+" 行");
ps.close();
conn.close();
%>
</body>
</html>