连接数据库的主要注意事项!!
我使用的是myeclipes,区别于eclipes的目录结构,但是内容都是一样的!!
导入的包:
1.java.util.*
2. java.sql.*
连接Mysql的jar包:
- mysql-connector-java-5.1.7-bin.jar(放在web-info/lib/下面)
整体结构如下:
云数据库中的两个字段和两个数据:
我们要做的就是 连接数据库之后,将这个两个数据输出在网页上。
index.jsp的源码
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
This is my JSP page. <br>
<table border="1">
<tr>
<th>name</th>
<th>sex</th>
</tr>
<%
try {
Class.forName("com.mysql.jdbc.Driver"); //加载MYSQL JDBC驱动程序 //Class.forName("org.gjt.mm.mysql.Driver");
System.out.println("Success loading Mysql Driver!");
}
catch (Exception e) {
System.out.print("Error loading Mysql Driver!");
e.printStackTrace();
}
try {
Connection connect = DriverManager.getConnection(
"jdbc:mysql://123.207.149.102:3305/xx(数据库名字)","root","xxxxxx");
//连接URL为 jdbc:mysql//服务器地址/数据库名 ,后面的2个参数分别是登陆用户名和密码,端口号填自己数据库对外开放端口,如我的是3305,你的可能是3306
System.out.println("Success connect Mysql server!");
Statement stmt = connect.createStatement();
ResultSet rs = stmt.executeQuery("select * from emp");//emp是我的表的名字 ,这里替换成你的表名字
while (rs.next()) {
%>
<tr>
<td><%=rs.getString("name") %></td>
<td><%=rs.getString("sex") %></td>
</tr>
<%
}
rs.close();
connect.close();
}
catch (Exception e) {
System.out.print("get data error!");
e.printStackTrace();
}
%>
</table>
</body>
</html>