jsp+servlet增删改查和简单分页的代码详情-代码-最代码

首页>代码>jsp+servlet增删改查和简单分页>/hehe/src/com/util/JDBCUtil.java
01package com.util;
02 
03import java.sql.*;
04 
05public class JDBCUtil {
06 
07    public static Connection getconn(){
08        Connection conn=null;
09        try {
10            Class.forName("oracle.jdbc.driver.OracleDriver");
11            conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "orcl");
12        } catch (Exception e) {
13            // TODO Auto-generated catch block
14            e.printStackTrace();
15        }
16        return conn;
17    }
18    public static void close(PreparedStatement ps,Connection conn){
19        try {
20            ps.close();
21            conn.close();
22        } catch (SQLException e) {
23            // TODO Auto-generated catch block
24            e.printStackTrace();
25        }
26         
27    }
28    public static void close(ResultSet rs,PreparedStatement ps,Connection conn){
29        try {
30            rs.close();
31            ps.close();
32            conn.close();
33        } catch (SQLException e) {
34            // TODO Auto-generated catch block
35            e.printStackTrace();
36        }
37         
38    }
39}