67,513
社区成员
发帖
与我相关
我的任务
分享
1、mysql5 绿色版
创建数据库
create database javassdb;
创建表:
>use javassdb;
>create table tbl_user(id int auto_increment Primary Key,
username varchar(200),
email varchar(200),
password varchar(200)) ;
>insert into tbl_user(username,email,password) values('A', 'A@163.com', 'A') ;
>insert into tbl_user(username,email,password) values('B', 'B@163.com', 'B') ;
>insert into tbl_user(username,email,password) values('C', 'C@163.com', 'C') ;
2、下载tomcat 在tomcat的 webapps目录中创建
myTest1
myTest1\index.jsp
myTest1\WEB-INF\web.xml
myTest1\WEB-INF\classes
myTest1\WEB-INF\lib\mysql-connector-java-5.0.8-bin.jar
3、web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
<display-name>TestWeb</display-name>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
</web-app>
4、index.jsp
<%@ page language="java" import="com.mysql.jdbc.*,java.sql.Connection, java.sql.DriverManager,java.sql.PreparedStatement,java.sql.ResultSet " pageEncoding="UTF-8"%>
<HTML>
<BODY>
<H3>Access MySQL DB Example</H3>
<table border="2">
<tr>
<td> id</td>
<td> 名称</td>
<td> 邮箱</td>
<td> 密码</td>
</tr>
<%
Class.forName("com.mysql.jdbc.Driver"); //加载驱动
Connection conn = DriverManager.getConnection("jdbc:mysql://192.168.0.44:3306/javassdb",
"root","root");//创建连接
String sql ="select id , username, email , password from tbl_User " ;
PreparedStatement pstmt = null ;
ResultSet rs = null ;
try{
pstmt = conn.prepareStatement(sql) ; //
rs = pstmt.executeQuery() ;//查询
while(rs.next()){ //遍历查询结构,现实在页面中
%>
<tr>
<td><%=rs.getInt("id" )%></td>
<td><%=rs.getString("username")%></td>
<td><%=rs.getString("email")%></td>
<td><%=rs.getString("password")%></td>
</tr>
<%
}
}catch(Exception e){
e.printStackTrace();
}finally{
try{
if (rs != null) rs.close() ;
if (pstmt != null) pstmt.close() ;
if (conn != null) conn.close() ;
}catch(Exception e){
e.printStackTrace() ;
}
}
%>
</table>
</BODY>
</HTML>
5、启动tomcat
6、IE 地址栏:http://localhost:8080/myTest 即可看到效果
1、mysql5 绿色版
创建数据库
create database javassdb;
创建表:
>use javassdb;
>create table tbl_user(id int auto_increment Primary Key,
username varchar(200),
email varchar(200),
password varchar(200)) ;
>insert into tbl_user(username,email,password) values('A', 'A@163.com', 'A') ;
>insert into tbl_user(username,email,password) values('B', 'B@163.com', 'B') ;
>insert into tbl_user(username,email,password) values('C', 'C@163.com', 'C') ;
2、下载tomcat 在tomcat的 webapps目录中创建
myTest2
myTest2\index.jsp
myTest2\show.jsp
myTest2\WEB-INF\web.xml
myTest2\WEB-INF\classes\org\servlet\MyServlet.class
myTest2\WEB-INF\classes\org\vo\User.class
myTest2\WEB-INF\lib\mysql-connector-java-5.0.8-bin.jar
myTest2\WEB-INF\lib\servlet-api.jar
3、web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
<display-name>TestWeb</display-name>
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<servlet>
<servlet-name>MyServlet</servlet-name>
<servlet-class>org.servlet.MyServlet</servlet-class>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>MyServlet</servlet-name>
<url-pattern>/MyServlet</url-pattern>
</servlet-mapping>
</web-app>
4、index.jsp
<%@ page language="java" pageEncoding="UTF-8"%>
<HTML>
<BODY>
<H3>Access MySQL DB Example</H3>
<form action="MyServlet" method="post">
<input type="submit" value="查看" />
</form>
</BODY>
</HTML>
5、User.java
package org.vo;
public class User {
private int id ;
private String username ;
private String password ;
private String email ;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public User(){
}
public User(int id, String username, String password, String email) {
this.id = id;
this.username = username;
this.password = password;
this.email = email;
}
@Override
public String toString() {
return "User [id=" + id + ", username=" + username + ", password="
+ password + ", email=" + email + "]";
}
}
6、MyServlet.java
package org.servlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.vo.User;
public class MyServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
List list = new ArrayList();
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
User user = null;
String sql = "select id , username, email , password from tbl_User ";
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(
"jdbc:mysql://192.168.0.44:3306/javassdb", "root", "root");// 创建连接
pstmt = conn.prepareStatement(sql); //
rs = pstmt.executeQuery();// 查询
while (rs.next()) {
user = new User(rs.getInt("id" ), rs.getString("username"), rs.getString("email"), rs.getString("password")) ;
list.add(user) ;
}
req.getSession().setAttribute("users", list) ;
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (rs != null)
rs.close();
if (pstmt != null)
pstmt.close();
if (conn != null)
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
resp.sendRedirect("show.jsp") ;
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(req, resp);
}
}
8、启动tomcat
9、IE 地址栏:http://localhost:8080/myTest2 即可看到效果 然后点击 查看按钮
或者 http://localhost:8080/myTest2/MyServlet