Tomcat下JDBC连接样例
时间：2021-07-01 10:21:17
帮助过：38人阅读
<%@ page language="java" contentType="text/html; charset=UTF-8"
2 pageEncoding="UTF-8"
import="java.sql.*"%>
3 <!DOCTYPE html>
4 <html>
5 <head>
6 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
7 <title>接收表单数据</title>
8 </head>
9 <body>
10 <p>
获取文本框提交的信息：
11 <%
12
13
14 String JDBC_DRIVER = "com.mysql.jdbc.Driver"
;
15 String DB_URL = "jdbc:mysql://localhost:3306/first"
;
16
17
18 String USER = "root"
;
19 String PASS = "******"
;
20
21 Connection conn =
null;
22 Statement stmt =
null;
23 try{
24 //load driver
25 Class.forName("com.mysql.jdbc.Driver"
);
26
27 System.out.println("Connecting to database..."
);
28 //create connection
29 conn =
DriverManager.getConnection(DB_URL,USER,PASS);
30
31 System.out.println("Creating statement..."
);
32 //create query
33 stmt =
conn.createStatement();
34 String sql;
35 sql = "SELECT * FROM first.author"
;
36 ResultSet rs =
stmt.executeQuery(sql);
37 //get data
38 while(rs.next()){
39 int id = rs.getInt("id"
);
40 int age = rs.getInt("age"
);
41 String author = rs.getString("author"
);
42 String represent = rs.getString("represent"
);
43
44 System.out.print("ID: " +
id);
45 System.out.print(", Age: " +
age);
46 System.out.print(", Author: " +
author);
47 System.out.println(", Represent: " +
represent);
48 }
49 rs.close();
50 stmt.close();
51 conn.close();
52 }
catch(SQLException se){
53 se.printStackTrace();
54 }
catch(Exception e){
55 e.printStackTrace();
56 }
finally{
57 try{
58 if(stmt!=
null)
59 stmt.close();
60 }
catch(SQLException se2){
61 }
62 try{
63 if(conn!=
null)
64 conn.close();
65 }
catch(SQLException se){
66 se.printStackTrace();
67 }
68 }
69 System.out.println("Goodbye!"
);
70
71 %>
72 </body>
73 </html>
Tomcat下JDBC连接样例
标签：auth represent java test out except *** for ring
