jsp中连接数据库

 1 <%@ page language="java" contentType="text/html; charset=UTF-8"
 2     pageEncoding="UTF-8"%>
 3     <%@ page import="java.sql.*" %>
 4 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 5 <html>
 6 <head>
 7 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
 8 <title>学生信息</title>
 9 </head>
10 <body>
11 学生信息
12 <br>
13 <%
14 try
15 {
16 //1.连接数据库
17 //(1)加载驱动
18 Class.forName("oracle.jdbc.driver.OracleDriver");
19 //(2)得到连接
20 String strUrl = "jdbc:oracle:thin:@localhost:1521:ORCL";
21 Connection conn = DriverManager.getConnection(strUrl, "text", "123456");
22 //2.获得读取对象
23 Statement st=conn.createStatement();
24 ResultSet rs=st.executeQuery("select * from student");
25 //3.输出结果集
26 if(rs!=null)
27 {
28     
29     while(rs.next())
30     {
31         
32         out.print("sno="+rs.getString("sno")+"  ");
33         out.print("name="+rs.getString("sname")+"  ");
34         out.print("sex="+rs.getString("ssex")+"  ");
35         out.print("birthday="+rs.getString("sbirthday")+"  ");
36         out.print("class="+rs.getString("class")+"<a href='DeleteStudent?sno="+rs.getString("sno")+"'>【删除】</a><br>");
37         
38     }
39     rs.close();
40 }
41 //。释放资源
42 rs.close();
43 st.close();
44 conn.close();
45 
46 }
47 catch(Exception e)
48 {
49     e.printStackTrace();
50 }
51 %>
52 增加学生信息
53 <form action="ServletStudent" method="post">
54 学号<input type="text" name="sno"><br>
55 姓名<input type="text" name="sname"><br>
56 性别<input type="text" name="ssex"><br>
57 生日<input type="text" name="sbirthday"><br>
58 班级<input type="text" name="class"><br>
59 <input type="submit" value="保存">
60 </form>
61 
62 </body>
63 </html>

 1 <%@ page language="java" contentType="text/html; charset=UTF-8"
 2     pageEncoding="UTF-8"%>
 3     <%@ page import="java.sql.*" %>
 4 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 5 <html>
 6 <head>
 7 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
 8 <title>学生信息</title>
 9 </head>
10 <body>
11 学生信息
12 <br>
13 <%
14 try
15 {
16 //1.连接数据库
17 //(1)加载驱动
18 Class.forName("oracle.jdbc.driver.OracleDriver");
19 //(2)得到连接
20 String strUrl = "jdbc:oracle:thin:@localhost:1521:ORCL";
21 Connection conn = DriverManager.getConnection(strUrl, "text", "123456");
22 //2.获得读取对象
23 Statement st=conn.createStatement();
24 ResultSet rs=st.executeQuery("select * from student");
25 //3.输出结果集
26 if(rs!=null)
27 {
28     
29     while(rs.next())
30     {
31         
32         out.print("sno="+rs.getString("sno")+"  ");
33         out.print("name="+rs.getString("sname")+"  ");
34         out.print("sex="+rs.getString("ssex")+"  ");
35         out.print("birthday="+rs.getString("sbirthday")+"  ");
36         out.print("class="+rs.getString("class")+"<a href='DeleteStudent?sno="+rs.getString("sno")+"'>【删除】</a><br>");
37         
38     }
39     rs.close();
40 }
41 //。释放资源
42 rs.close();
43 st.close();
44 conn.close();
45 
46 }
47 catch(Exception e)
48 {
49     e.printStackTrace();
50 }
51 %>
52 增加学生信息
53 <form action="ServletStudent" method="post">
54 学号<input type="text" name="sno"><br>
55 姓名<input type="text" name="sname"><br>
56 性别<input type="text" name="ssex"><br>
57 生日<input type="text" name="sbirthday"><br>
58 班级<input type="text" name="class"><br>
59 <input type="submit" value="保存">
60 </form>
61 
62 </body>
63 </html>

 1 package hanqi;
 2 
 3 import java.io.IOException;
 4 import javax.servlet.Filter;
 5 import javax.servlet.FilterChain;
 6 import javax.servlet.FilterConfig;
 7 import javax.servlet.ServletException;
 8 import javax.servlet.ServletRequest;
 9 import javax.servlet.ServletResponse;
10 
11 public class MyFilter implements Filter 
12 {
13     public MyFilter()
14     {
15       
16     }
17     public void destroy() 
18     {
19         
20     }
21     public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException
22     {
23         response.setContentType("text/html");
24         response.setCharacterEncoding("UTF-8");
25         request.setCharacterEncoding("UTF-8");
26         chain.doFilter(request, response);
27     }
28     public void init(FilterConfig fConfig) throws ServletException
29     {
30         
31     }
32 }

 1 package hanqi;
 2 
 3 import java.io.IOException;
 4 import java.sql.*;
 5 import java.text.SimpleDateFormat;
 6 
 7 import javax.servlet.ServletException;
 8 import javax.servlet.http.HttpServlet;
 9 import javax.servlet.http.HttpServletRequest;
10 import javax.servlet.http.HttpServletResponse;
11 
12 public class ServletStudent extends HttpServlet
13 {
14     private static final long serialVersionUID = 1L;
15     public ServletStudent()
16     {
17         super();    
18     }
19     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
20     {
21         //处理保存数据
22         //1.接收参数
23         String sno=request.getParameter("sno");
24         String sname=request.getParameter("sname");
25         String ssex=request.getParameter("ssex");
26         String sbirthday=request.getParameter("sbirthday");
27         String sclass=request.getParameter("class");
28         //2.验证
29         if(sno!=null&&sno.trim().length()!=0
30                 &&sname!=null&&sname.trim().length()!=0)
31         {
32         try
33         {
34         //连接数据库
35         Class.forName("oracle.jdbc.driver.OracleDriver");
36         String strUrl = "jdbc:oracle:thin:@localhost:1521:ORCL";
37         Connection conn = DriverManager.getConnection(strUrl, "text", "123456");
38         //3.保存
39         PreparedStatement pst=conn.prepareStatement("insert into student(sno,sname,ssex,sbirthday,class)"+"values(?,?,?,?,?)");
40         //日期的转换String 转成Date型
41         //关于日期格式的类
42         //可以进行日期转换
43         SimpleDateFormat adf=new SimpleDateFormat("yyyy-MM-dd");
44         java.util.Date bir=adf.parse(sbirthday);
45         //使用long型的时间构造sql。Date
46         Date sqlBir=new Date(bir.getTime());
47         pst.setString(1, sno);
48         pst.setString(2, sname);
49         pst.setString(3, ssex);
50         pst.setDate(4,sqlBir);
51         pst.setString(5, sclass);
52         pst.executeUpdate();
53         pst.close();
54         conn.close();
55         //4.跳转页面
56                 response.getWriter().print("保存成功");
57                 response.setHeader("refresh","3; URL=index.jsp");
58         }
59         
60         catch(Exception e)
61         {
62             e.printStackTrace();
63             response.getWriter().print("保存失败");
64             response.setHeader("refresh","3; URL=index.jsp");
65         }
66         }
67         else
68         {
69             response.getWriter().print("请正确提交数据");
70             response.setHeader("refresh","3; URL=index.jsp");
71         }
72         
73     }
74     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException 
75     {
76         doGet(request, response);
77     }
78 
79 }

 1 package hanqi;
 2 
 3 import java.io.IOException;
 4 import java.sql.Connection;
 5 import java.sql.Date;
 6 import java.sql.DriverManager;
 7 import java.sql.PreparedStatement;
 8 import java.text.SimpleDateFormat;
 9 
10 import javax.servlet.ServletException;
11 import javax.servlet.http.HttpServlet;
12 import javax.servlet.http.HttpServletRequest;
13 import javax.servlet.http.HttpServletResponse;
14 
15 public class DeleteStudent extends HttpServlet {
16     private static final long serialVersionUID = 1L;
17     public DeleteStudent() {
18         super();
19     }
20     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
21     {
22         String sno=request.getParameter("sno");
23         if(sno!=null&&sno.trim().length()!=0)
24         {
25         try
26         {
27     
28         Class.forName("oracle.jdbc.driver.OracleDriver");
29         String strUrl = "jdbc:oracle:thin:@localhost:1521:ORCL";
30         Connection conn = DriverManager.getConnection(strUrl, "text", "123456");
31         PreparedStatement pst=conn.prepareStatement("delete student where sno=?");
32         pst.setString(1, sno);
33         pst.executeUpdate();
34         pst.close();
35         conn.close();
36                 response.getWriter().print("删除成功");
37                 response.setHeader("refresh","3; URL=index.jsp");
38         }
39         catch(Exception e)
40         {
41             e.printStackTrace();
42             response.getWriter().print("删除失败");
43             response.setHeader("refresh","3; URL=index.jsp");
44         }
45         }
46         else
47         {
48             response.getWriter().print("请正确提交数据");
49             response.setHeader("refresh","3; URL=index.jsp");
50         }
51     }
52     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
53     
54         doGet(request, response);
55     }
56 
57 }

posted @ 2016-07-05 22:22 明天会更好！！！！阅读(195) 评论(0) 收藏举报

刷新页面返回顶部