java 简单servlet实例

来源：互联网发布：小学生英语配音软件编辑：程序博客网时间：2024/05/18 02:39

我这里连接的是sqlserver2008数据库，所以你得去微软官网下载一个Microsoft SQL Server JDBC Driver jar包

下载地址如下：http://www.microsoft.com/en-us/download/details.aspx?id=28562

效果如下：

TestSqlHttpServlet类

import java.util.List;import java.io.IOException;import java.io.PrintWriter;import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class TestSqlHttpServlet extends HttpServlet {@Overrideprotected void doGet(HttpServletRequest req, HttpServletResponse resp)throws ServletException, IOException {resp.setContentType("text/html;charset=utf-8");PrintWriter pw = resp.getWriter();pw.println("<html xmlns=\"http://www.w3.org/1999/xhtml\">");pw.println("<head>");pw.println("<title>读取到所有传递的参数</title>");pw.println("<style type=\"text/css\"> ");pw.println("body { font: normal 11px auto \"Trebuchet MS\", Verdana, Arial, Helvetica, sans-serif; color: #4f6b72; background: #E6EAE9; } ");pw.println("#mytable { width: 700px; padding: 0; margin: 0; }");pw.println("th { font: bold 11px \"Trebuchet MS\", Verdana, Arial, Helvetica, sans-serif; color: #4f6b72; border-right: 1px solid #C1DAD7; border-bottom: 1px solid #C1DAD7; border-top: 1px solid #C1DAD7; letter-spacing: 2px; text-transform: uppercase; text-align: left; padding: 6px 6px 6px 12px; background: #CAE8EA ; } ");pw.println("td { border-right: 1px solid #C1DAD7; border-bottom: 1px solid #C1DAD7; background: #fff; font-size:11px; padding: 6px 6px 6px 12px; color: #4f6b72; }");pw.println("</style>");pw.println("</head>");pw.println("<body>");pw.println("<table id=\"mytable\" cellspacing=\"0\" align=\"center\" ><tr>");pw.println("<th >用户名</th >");pw.println("<th >姓名</th >");pw.println("<th >联系电话</th ></tr>");List<User> list = LoadUserList();for (User user : list) {pw.println("<tr><td>" + user.getLogincode() + "</td>");pw.print("<td>" + user.getFullname() + "</td>");pw.print("<td>" + user.getMobileNo() + "</td>");pw.println("</tr>");}pw.println("</table>");pw.println("</body>");pw.println("</html>");}protected List<User> LoadUserList() {List<User> list = new ArrayList<User>();SqlDbHelper dbHelper = new SqlDbHelper();ResultSet rSet = dbHelper.GetResultSet(" SELECT LoginCode,FullName,MobileNo FROM UT_User ");try {while (rSet.next()) {User user = new User();user.setLogincode(rSet.getString(1));user.setFullname(rSet.getString(2));user.setMobileNo(rSet.getString(3));list.add(user);}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}return list;}@Overrideprotected void doPost(HttpServletRequest req, HttpServletResponse resp)throws ServletException, IOException {// TODO Auto-generated method stubthis.doGet(req, resp);}}

SqlDbHelper类

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class SqlDbHelper {// 数据库驱动private final String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";// 数据库URLprivate final String url = "jdbc:sqlserver://192.168.1.57\\sql2008r2;databaseName=数据库名";// 数据库用户名private final String username = "sa";// 数据库连接密码private final String pwd = "123456";private Connection conn = null;public void getConn() {if (conn != null)return;try {Class.forName(driver);conn = DriverManager.getConnection(url, username, pwd);} catch (Exception e) {e.printStackTrace();}}public ResultSet GetResultSet(String strSql) {getConn();ResultSet rs = null;Statement stmt = null;try {stmt = conn.createStatement();rs = stmt.executeQuery(strSql);} catch (Exception ex) {System.out.println(ex.getMessage());closefree(rs, stmt, conn);} return rs;}public void closefree(ResultSet rs, Statement st, Connection conn) {close(rs);close(st);close(conn);}private void close(Connection conn) {if (conn != null) {try {conn.close();} catch (Exception e) {e.printStackTrace();}}}private void close(ResultSet rs) {try {if (rs != null) {rs.close();}} catch (Exception err) {err.printStackTrace();}}private void close(Statement stmt) {if (stmt != null) {try {stmt.close();} catch (Exception e) {e.printStackTrace();}}}}

User 类

public class User {private String logincode;private String fullname;private String mobileNo;public String getLogincode() {return logincode;}public void setLogincode(String logincode) {this.logincode = logincode;}public String getFullname() {return fullname;}public void setFullname(String fullname) {this.fullname = fullname;}public String getMobileNo() {return mobileNo;}public void setMobileNo(String mobileNo) {this.mobileNo = mobileNo;}}

美丽元素返利网（http://www.mlyuansu.com）