1、导入数据库需要的jar
mysql:mysql-connector-java-3.1.11-bin.jar
sqlserver:msbase.jar、mssqlserver.jar、msutil.jar、sqljdbc.jar
2、jsp页面代码
1 <%@page import="java.text.SimpleDateFormat"%> 2 <%@page import="java.sql.*"%> 3 <%@ page contentType="text/html; charset=utf-8"%> 4 <%@ taglib prefix="s" uri="/struts-tags"%> 5 <head> 6 7 <script type="text/javascript"> 8 </script> 9 </head> 10 <html> 11 <body> 12 <table align="center" border="1"> 13 <tr> 14 <th>ID</th> 15 <th>姓名</th> 16 <th>年龄</th> 17 </tr> 18 <% 19 Connection conn = null; 20 Statement stmt = null; 21 ResultSet rs = null; 22 //sqlserver:com.microsoft.sqlserver.jdbc.SQLServerDriver 23 Class.forName("com.mysql.jdbc.Driver"); 24 //sqlserver:jdbc:sqlserver://127.0.0.1:1433;DatabaseName=CETTICBusinessSystemDB 25 String url="jdbc:mysql://localhost:3306/test"; 26 String root = "root"; 27 String password = "111111"; 28 conn = DriverManager.getConnection(url,root,password); 29 stmt = conn.createStatement(); 30 rs = stmt.executeQuery("select * from students"); 31 while(rs.next()) { 32 %> 33 <tr> 34 <td><%=rs.getString("sid")%></td> 35 <td><%=rs.getString("sname")%></td> 36 <td><%=rs.getString("sage")%></td> 37 </tr> 38 <%} 39 rs.close(); 40 conn.close(); 41 stmt.close(); 42 43 %> 44 </table> 45 </body> 46 </html>
页面效果图