JDBC连接数据库例子--一般,封装,单例模式封装
来源:互联网 发布:入我相思门 知我相思苦 编辑:程序博客网 时间:2024/04/29 22:50
一般:
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){
e.printStackTrace();
}finally{
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(st!=null){
try {
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
}
封装
JdbcTest.java
package day01;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JdbcTest {
public static void main(String[] args){
Connection conn=null;
Statement st=null;
ResultSet rs=null;
/*
JdbcUnit.Driver();
conn=JdbcUnit.conn();
*/
//调用单例模式
JdbcUnitSing.getJdbcUnitSing().Driver();
conn=JdbcUnitSing.getJdbcUnitSing().conn();
try {
st=conn.createStatement();
String sql="select * from user1";
rs=st.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getInt("id")+","+rs.getString("name"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
JdbcUnit.closeConn(conn, st, rs);
}
}
用static 封装
jdbcUnit.java
package day01;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public final class JdbcUnit {
private static String url="jdbc:oracle:thin:@OWEYOJ5DU7AAHZZ:1521:ORCL";
private static String name="jbit";
private static String password="bdqn";
private static Connection conn=null;
//实例化一次
private JdbcUnit(){
}
public static void Driver(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
public static Connection conn(){
try {
return conn=DriverManager.getConnection(url,name,password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public static void closeConn(Connection conn,Statement st,ResultSet rs){
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(st!=null){
try {
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
单例模式封装
JdbcUintSing.java
package day01;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public final class JdbcUnitSing {
private static String url="jdbc:oracle:thin:@OWEYOJ5DU7AAHZZ:1521:ORCL";
private static String name="jbit";
private static String password="bdqn";
private static Connection conn=null;
//实例化一次
private JdbcUnitSing(){
}
//只创建一个实例
private static JdbcUnitSing jus = new JdbcUnitSing();
//给外界提供实例的访问对象
public static JdbcUnitSing getJdbcUnitSing(){
return jus;
}
public void Driver(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
public Connection conn(){
try {
return conn=DriverManager.getConnection(url,name,password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public void closeConn(Connection conn,Statement st,ResultSet rs){
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(st!=null){
try {
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
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){
e.printStackTrace();
}finally{
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(st!=null){
try {
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
}
封装
JdbcTest.java
package day01;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JdbcTest {
public static void main(String[] args){
Connection conn=null;
Statement st=null;
ResultSet rs=null;
/*
JdbcUnit.Driver();
conn=JdbcUnit.conn();
*/
//调用单例模式
JdbcUnitSing.getJdbcUnitSing().Driver();
conn=JdbcUnitSing.getJdbcUnitSing().conn();
try {
st=conn.createStatement();
String sql="select * from user1";
rs=st.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getInt("id")+","+rs.getString("name"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
JdbcUnit.closeConn(conn, st, rs);
}
}
用static 封装
jdbcUnit.java
package day01;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public final class JdbcUnit {
private static String url="jdbc:oracle:thin:@OWEYOJ5DU7AAHZZ:1521:ORCL";
private static String name="jbit";
private static String password="bdqn";
private static Connection conn=null;
//实例化一次
private JdbcUnit(){
}
public static void Driver(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
public static Connection conn(){
try {
return conn=DriverManager.getConnection(url,name,password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public static void closeConn(Connection conn,Statement st,ResultSet rs){
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(st!=null){
try {
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
单例模式封装
JdbcUintSing.java
package day01;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public final class JdbcUnitSing {
private static String url="jdbc:oracle:thin:@OWEYOJ5DU7AAHZZ:1521:ORCL";
private static String name="jbit";
private static String password="bdqn";
private static Connection conn=null;
//实例化一次
private JdbcUnitSing(){
}
//只创建一个实例
private static JdbcUnitSing jus = new JdbcUnitSing();
//给外界提供实例的访问对象
public static JdbcUnitSing getJdbcUnitSing(){
return jus;
}
public void Driver(){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
public Connection conn(){
try {
return conn=DriverManager.getConnection(url,name,password);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public void closeConn(Connection conn,Statement st,ResultSet rs){
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(st!=null){
try {
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(conn!=null){
try {
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
- JDBC连接数据库例子--一般,封装,单例模式封装
- JDBC连接数据库封装
- php单例模式连接数据库封装类
- php单例模式连接数据库封装类
- JAVA封装连接数据库【JDBC】
- 单例模式封装PDO链接数据库
- JDBC连接数据库(单例设计模式)
- JDBC单例模式连接数据库方式
- JDBC 连接数据库之单例模式
- java(JDBC连接数据库)[完整版封装]
- JDBC连接mysql数据库CRUD封装类
- java(JDBC连接数据库)[完整版封装]
- java(JDBC连接数据库)[完整版封装]
- java(JDBC连接数据库)[完整版封装]
- java(JDBC连接数据库)[完整版封装]
- java(JDBC连接数据库)[完整版封装]
- java(JDBC连接数据库)[完整版封装]
- java(JDBC连接数据库)[完整版封装]
- Android--Android自定义权限
- android自定义弹出层
- 错误:stack around the variable “XX” was corrupted
- build.xml备份
- 免安装Oracle客户端使用PL/SQL连接Oracle
- JDBC连接数据库例子--一般,封装,单例模式封装
- 内存泄漏检测
- 判定字符串
- 条码扫描二维码扫描——ZXing android 源码简化
- iterator 的遍历 循环输出数字,页码
- hdu 2063 二分图—最大匹配
- Linux TCP 系统参数配置
- 最小生成树
- 来电和HOME按钮都会触发onPause()