利用servlet访问MSSQL数据库

最新推荐文章于 2025-05-12 10:43:22 发布

原创最新推荐文章于 2025-05-12 10:43:22 发布 · 2.9k 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#servlet #exception #string #sqlserver #microsoft #constructor

数据库专栏收录该内容

29 篇文章

订阅专栏

本文介绍了一个使用Servlet进行数据库操作的例子，包括删除表中记录和查询显示数据。通过简单的JSP页面选择操作类型，Servlet接收请求并执行相应的数据库操作。

除了可以利用javabean访问数据库外，还可以利用servlet访问数据库。觉得servlet更方便一些。贴一个例子，方便以后参考。

本例子时根据用户选择，是删除表中内容还是显示表中内容。

servlet代码：

import java.io.IOException; import java.io.PrintWriter; import java.sql.*; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class DBServlet extends HttpServlet { private static final long serialVersionUID = 1L; private Connection conn; /** * @see HttpServlet#HttpServlet() */ public DBServlet() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // 设置response和request的编码方式，防止中文乱码 request.setCharacterEncoding("GBK"); response.setContentType("text/html;charset=GBK"); PrintWriter print=response.getWriter(); String command=request.getParameter("submit"); if(command.equals("delete")) { deleterow(); print.println("顺利删除"); } else if(command.equals("show")) { ResultSet rs=getResult(); try { if(rs!=null) { while(rs.next()) { print.println(rs.getString("username")); } rs.close(); conn.close(); } else { print.println("ResultSet为空"); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } //建立连接 protected void addConnection() { String url1="com.microsoft.jdbc.sqlserver.SQLServerDriver"; String url2="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=book"; String username="sa"; String passwrd="***"; try { Class.forName(url1); conn=DriverManager.getConnection(url2,username,passwrd); } catch(Exception ex) { } } //删除表中数据 protected void deleterow() { addConnection(); try { String sql="use book;delete from user1"; Statement stm=conn.createStatement(); stm.execute(sql); stm.close(); conn.close(); } catch(Exception ex) { } } //查询表中数据 protected ResultSet getResult() { addConnection(); try { String sql1="use book;select * from user1"; Statement stm=conn.createStatement(); ResultSet rs=stm.executeQuery(sql1); return rs; } catch(Exception ex) { } return null; } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { //做与doGet一样的事情 this.doGet(request,response); } }

JSP代码，如下，用了servlet之后，显得非常简单。

<%@ page language="java" contentType="text/html; charset=GBK" pageEncoding="GBK"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=GBK"> <title>Insert title here</title> </head> <body> <form method="post" action="DBServlet"> <table> <tr> <td> <input name="submit" type="submit" value="delete"/> </td> <td> <input name="submit" type="submit" value="show"/> </td> </tr> </table> </form> </body> </html>