一、编写一个web程序
本文根据工作实际项目，编写一个web程序：实现防伪码查询页面，输入防伪码，点击查询，查询数据库并作出判断，将结果显示在查询页面。
1、需要添加的buildpath：ojdbc14.jarclasses12.jar
2、编写searchresult.jsp文件：（刚入门格式不规范）
1 <%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
2 <!--%
3 String path = request.getContextPath();
4 String basePath = request.getScheme() + "://"
5 + request.getServerName() + ":" + request.getServerPort()
6 + path + "/";
7 %>-->
8 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
9 <%@ page import="java.sql.*"%>
10 <%@ page import="testsample001.check"%>
11 <html>
12 <head>
13 <!--base href="<!--%=basePath%>">-->
14 <title>查询结果</title>
15 <meta http-equiv="pragma" content="no-cache">
16 <meta http-equiv="cache-control" content="no-cache">
17 <meta http-equiv="expires" content="0">
18 <meta http-equiv="keywords" content="keyword1，keyword2，keyword3">
19 <meta http-equiv="description" content="This is my page">
20 <!--<link rel="stylesheet" type="text/css" href="styles.css"> -->
21 </head>
22 <body>
23 <br>
24 <br>
25 <br>
26 <table>
27 <tr>
28 <td>
29 <form action="/testsample001/testservlet" method="post">
30 防伪码
31 <!--input name="fangweima" id="t1" type="text">-->
32 <!--input name="searchbtn" type="button" value='查询' onclick="check1()">-->
33 <!--input name="result" id="t2" type="text"-->
34 <input type="text" id="t1" name="t1" value="<%=session.getAttribute("t1")%>" />
35 <!--input type="text" id="t2" name="t2" value="<%=session.getAttribute("t2")%>"/>-->
36 <input type="submit" value="查询"/>
37 <br>
38 查询结果：<%=session.getAttribute("t2")%>;
39 </form>
40 </td>
41 </tr>
42 </table>
43 </body>
44 </html>
3、编写check.java文件
1 package testsample001;
2
3 import java.sql.Connection;
4 import java.sql.DriverManager;
5 import java.sql.ResultSet;
6 import java.sql.SQLException;
7 import java.sql.Statement;
8
9 public class check {
10 private Connection con;
11 private String user = "deejuser";
12 // private String user = "sys as sysdba";
13 private String password = "deejuser";
14 private String className = "oracle.jdbc.driver.OracleDriver";
15 // private String url="jdbc:oracle:oci@localhost:1158:orcl";这个url可能无效
16 private String url = "jdbc:oracle:thin:@zs-PC:1521:ytdf";
17
18 public String ConnectOracle(String productno) {
19 try {
20 Class.forName(className);
21 // System.out.println("加载数据库驱动成功！");
22 // System.out.println(productno);
23 String resultInfo = getCon(productno);
24 closed();
25 return resultInfo;
26 } catch (ClassNotFoundException e) {
27 // System.out.println("加载数据库驱动失败！");
28 e.printStackTrace();
29 return "加载数据库驱动失败！";
30 }
31 }
32
33 /** 创建数据库连接 */
34 // public Connection getCon(String productno) {
35 public String getCon(String productno) {
36 try {
37 con = DriverManager.getConnection(url， user， password);
38 // System.out.println("创建数据库连接成功！");
39 Statement stmt = con
40 .createStatement(ResultSet.TYPE_SCROLL_SENSITIVE，
41 ResultSet.CONCUR_UPDATABLE);
42 String sql = "select * from product t where t.packagsn="
43 + productno;
44 // System.out.print(sql);
45 ResultSet rs = stmt.executeQuery(sql);
46 if (rs.next())
47 return "防伪码存在！";
48 else
49 return "防伪码不存在！";
50 } catch (SQLException e) {
51 // System.out.print(con);
52 // System.out.println("创建数据库连接失败！");
53 con = null;
54 e.printStackTrace();
55 return "数据库连接失败！";
56 }
57 // return con;
58 }
59
60 public void closed() {
61 try {
62 if (con != null) {
63 con.close();
64 }
65 } catch (SQLException e) {
66 System.out.println("关闭con对象失败！");
67 e.printStackTrace();
68 }
69 }
70 }
4、编写testservlet.java文件
1 package testsample002;
2
3 import java.io.IOException;
4
5 import javax.servlet.ServletException;
6 import javax.servlet.annotation.WebServlet;
7 import javax.servlet.http.HttpServlet;
8 import javax.servlet.http.HttpServletRequest;
9 import javax.servlet.http.HttpServletResponse;
10
11 import testsample001.check;
12
13 /**
14 * Servlet implementation class testservlet
15 */
16 @WebServlet("/testservlet")
17 public class testservlet extends HttpServlet {
18 private static final long serialVersionUID = 1L;
19
20 /**
21 * @see HttpServlet#HttpServlet()
22 */
23 public testservlet() {
24 super();
25 // TODO Auto-generated constructor stub
26 }
27
28 /**
29 * @see HttpServlet#doGet(HttpServletRequest request， HttpServletResponse
30 * response)
31 */
32 protected void doGet(HttpServletRequest request，
33 HttpServletResponse response) throws ServletException， IOException {
34 // TODO Auto-generated method stub
35 }
36
37 /**
38 * @see HttpServlet#doPost(HttpServletRequest request， HttpServletResponse
39 * response)
40 */
41 protected void doPost(HttpServletRequest request，
42 HttpServletResponse response) throws ServletException， IOException {
43 // TODO Auto-generated method stub
44 String value = request.getParameter("t1");// 获取前台页面传递过来的数据
45 // request.getSession(false).setAttribute("t1"， value);// 将数据放到session中
46 check connor = new check();
47 String resultInfo = connor.ConnectOracle(value);
48 request.getSession(false).setAttribute("t2"， resultInfo);// 将数据放到session中
49 request.getSession(false).setAttribute("t1"， value);
50 response.sendRedirect("/testsample001/searchresult.jsp");// 跳转回提交的页面
51
52 }
53
54 }
5、设置项目的起始页面（tomcat服务配置-web.xml）
1 <welcome-file-list>
2 <welcome-file>index.html</welcome-file>
3 <welcome-file>index.htm</welcome-file>
4 <welcome-file>searchresult.jsp</welcome-file>
5 </welcome-file-list>
6、实现结果：
7、导出jar包（在要生成jar的项目上右击，选择菜单上的Export(导出)），导出oracleconnect.jar
