package jdbc;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
import java.sql.PreparedStatement;
/**
* jdbc连接数据库，操作数据库的实体类
*
* @author yzm
*
*/
public class MySQLJDBCConnectionUtil {
private static String url;// url路径
private static String driver;// 驱动
private static String username;// 用户名
private static String password;// 密码
static {
try {
InputStream is = MySQLJDBCConnectionUtil.class.getClassLoader()
.getResourceAsStream("jdbc/jdbc.properties");
Properties prop = new Properties();
prop.load(is);
is.close();
url = prop.getProperty("url");
driver = prop.getProperty("driver");
username = prop.getProperty("username");
password = prop.getProperty("password");
Class.forName(driver);
} catch (IOException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
/**
* 获得连接
*
* @return
* @throws SQLException
*/
public static Connection getConnection() throws SQLException {
return DriverManager.getConnection(url, username, password);
}
/**
* 关闭连接
*
* @param con
*/
public static void closeCon(Connection con) {
try {
if (con != null) {
con.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* 关闭预编译
*
* @param stmt
*/
public static void closeStmt(PreparedStatement stmt) {
try {
if (stmt != null) {
stmt.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* 关闭结果集
*
* @param rs
*/
public static void closeRs(ResultSet rs) {
try {
if (rs != null) {
rs.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
/**
* 关闭没有结果集的连接
*
* @param con
* @param stmt
*/
public static void close(Connection con, PreparedStatement stmt) {
closeCon(con);
closeStmt(stmt);
}
/**
* 关闭有结果集的连接
*
* @param con
* @param stmt
* @param rs
*/
public static void close(Connection con, PreparedStatement stmt,
ResultSet rs) {
close(con, stmt);
closeRs(rs);
}
/**
* 测试主方法
*
* @param args
* @throws SQLException
*/
public static void main(String[] args) throws SQLException {
Connection c = getConnection();
System.out.println(c);
}
}
import java.sql.*;
public class DatabaseOrcale {
public DatabaseOrcale() {
}
public static void main(String[] args) {
String
OrcaleDriver="orcale.jdbc.driver.OrcaleDriver";
String
CoonStr="jdbc:orcale.thin:@主机 host:端口号:数据库名","用户名","密码";
String sql="select*from Test01";
Connecttion Coon=null;
ResultSet ts=null;
try{
Class.forName(OrcaleDriver);
Coon=DriverManager.getConnection(ConnStr);//与DBMS建立连接
Statement
stmt=Conn.createStateStatement();
rs=stmt.executeQuery(sql);
System.out.println("列1 列2 列3 列4");
while(rs.next()){
System.out.print("1"+rs.getInt("列1"))；
System.out.print("2"+rs.getString("列2"))；
//……………………
System.out.println();
}
rs.close();
stmt.close();
Conn.close();
}
catch(Exception e){
e.getMessage();
e.printStackTrace();
}
}
}
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024