java中单例模式连接数据库_JDBC连接数据库例子--一般，封装，单例模式封装

一般：

Test.java

package day01;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class Test {

public static void main(String[] args) {

Jdbc();

}

public static void Jdbc(){

Connection conn=null;

java.sql.Statement st=null;

ResultSet rs=null;

PreparedStatement pst=null;

try{

Class.forName("oracle.jdbc.driver.OracleDriver");

}catch(ClassNotFoundException e){

e.printStackTrace();

}try{

conn=DriverManager.getConnection("jdbc:oracle:thin:@OWEYOJ5DU7AAHZZ:1521:ORCL", "jbit", "bdqn");

//Statement的使用

st=conn.createStatement();

String sql="select * from user1";

rs=st.executeQuery(sql);

while(rs.next()){

System.out.println(rs.getInt(1)+"  ,"+rs.getString(2));

}

//PreparedStatement的使用

String sql1="insert into user1(id,name) values(?,?)";

pst=conn.prepareStatement(sql1);

pst.setInt(1, 2);

pst.setString(2, "niini");

pst.execute();

}catch(SQLException e){