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();
}
}
}
}