定义一个类来连接操作数据库

来源：互联网发布：考研英语90分经验知乎编辑：程序博客网时间：2024/06/04 15:16

package com.yourcompany.DB;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

// fubin www.cujava.com

public class DBU {

private String name;

private String password;

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password;

}

public DBU(){

}

public DBU(String name,String password){

this.name=name;

this.password=password;

}

Connection connection = null;

public void dblink() {

String serverName = "127.0.0.1";

String portNumber = "1521";

String sid = "oracle";

String url = "jdbc:oracle:thin:@" + serverName + ":" + portNumber

+ ":" + sid;

String username = "scott";

String password = "tiger";

try {

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

} catch (ClassNotFoundException e) {

System.out.println("数据库驱动类没找到");

}

try {

// 建立连接

connection = DriverManager.getConnection(url, username, password);

System.out.println("数据库连接成功！");

} catch (SQLException e) {

System.out.println("执行SQL语句异常！");

e.printStackTrace();

}

public void insert(){

dblink();

PreparedStatement pstmt=null;

try {

pstmt=connection.prepareStatement("INSERT INTO login(name,password)VALUES(?,?)");

connection.setAutoCommit(false);

pstmt.setString(1, name);

pstmt.setString(2, password);

pstmt.executeUpdate();

connection.commit();

System.out.print("提交了");

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally{

try {

pstmt.close();

connection.close();

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}