JAVA WEB_JSP的初步(14)JDBC

最新推荐文章于 2022-04-11 10:38:00 发布

学bu会喵de猫

最新推荐文章于 2022-04-11 10:38:00 发布

阅读量584

点赞数

分类专栏： JSP,SERVLET 文章标签： jdbc java jsp web null insert

本文链接：https://blog.csdn.net/hsttmht/article/details/7056210

版权

JSP,SERVLET 专栏收录该内容

27 篇文章 0 订阅

订阅专栏

<%@ page language="java" import="java.sql.*" pageEncoding="GBK"%>
<html>
	<head>
		<title>JDBC</title>
	</head>
	<body>
		<%!
			ResultSet rs = null;
			PreparedStatement pstmt = null;
			Connection conn = null;
		%>
		<%
			try {
				Class.forName("com.mysql.jdbc.Driver");
				conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydata","root", "root");
				pstmt = conn.prepareStatement("insert into student(Name,Age,Tel,Address) values (?, ?, ?,?)");
				pstmt.setString(1, "wang");
				pstmt.setInt(2, 21);
				pstmt.setString(3, "123456789");
				pstmt.setString(4, "shanghai");
				pstmt.executeUpdate();
				Statement st = conn.createStatement();
				rs = st.executeQuery("select * from student");
				while(rs.next()) {
					out.println(" " + rs.getString("Name"));
					out.println(" " + rs.getInt("Age"));
					out.println(" " + rs.getString("Tel"));
					out.println(" " + rs.getString("Address"));
					out.println("<br>");
				}
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			} catch (SQLException e) {
				e.printStackTrace();
			} finally {
				try {
					if (rs != null) {
				rs.close();
					}
					if (pstmt != null) {
				pstmt.close();
					}
					if (conn != null) {
				conn.close();
					}
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		%>
	</body>
</html>