SQLServer 的:
- package bzc.terry.database.sqlsver;
- /*
- *简单的与数据库连接的程序
- */
- import java.sql.*;
- public class DBConnectionModel {
- /**
- *此主方法中演示了与数据库建立连接并实现相关操作的步骤:
- *1、forName方法加载数据库驱动程序;
- *2、DriverManager的getConnection方法与数据库建立连接,并返回Connection接口的子类对象赋给conn;
- *3、conn对象调用createStatement方法,返回Statement的对象赋给stmt,
- * 通过此对象调用相应的方法实现对数据库的查询、修改等操作;
- *4、用ResuitSet的对象作为容器存放从数据库读取的记录并print将记录最终输出。
- */
- public static void main(String[] args) {
- Connection conn = null;
- Statement stmt = null;
- ResultSet rs= null;
- try {
- //装载驱动,以使系统识别此数据库
- Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
- } catch(ClassNotFoundException e) {
- System.out.println("Can't load driver!");
- System.exit(-1);
- }
- try {
- String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName = ManageMessage";
- String user = "sa";//数据库登陆名
- String password = "123";//数据库登陆密码
- //与装载并注册(即 register,在装载时自动完成)的数据库建立连接
- conn = DriverManager.getConnection(url, user, password);
- //创建 Statement 对象,以向数据库发送SQL语句
- stmt = conn.createStatement();
- String sql = "select * from message";
- rs = stmt.executeQuery(sql); //用一ResultSet对象来SQL语句查询的结果集
- //输出查询结果
- while(rs.next()) {
- System.out.print(rs.getInt("messID"));
- System.out.print("-->" + rs.getString("messName"));
- System.out.print("-->" + rs.getString("title"));
- System.out.println("-->" + rs.getString("content"));
- }
- } catch(SQLException e) {
- System.out.println(e);
- } finally {//关闭连接
- try{
- if(rs != null) {
- rs.close();
- rs = null;
- }
- if(stmt != null) {
- stmt.close();
- stmt = null;
- }
- if(conn != null) {
- conn.close();
- conn = null;
- }
- } catch(SQLException e) {
- e.printStackTrace();
- }
- }
- }
- }
MySQL 的:
- package bzc.terry.database.mysql;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- /**
- *
- *
- * @author Terry
- *
- */
- public class ConnMySqlDb {
- private Connection conn = null; // 用于取得数据库连接的对象
- private static String URL = "jdbc:mysql://localhost"; // 要连接的数据库 url
- private static String DATA = "mydata"; // 要访问的数据库
- private static String USER = "root"; // 登录数据库的用户名
- private static String PASSWORD = "root"; // 登录数据库的密码
- // 取得数据库的连接
- public Connection getConnection() {
- try {
- // 加ame("com.mysql.jdbc.Driver");
- 载数据库驱动
- Class.forN
- // 取得数据库连接
- conn = DriverManager.getConnection(
- URL + "/" + DATA + "?user=" + USER + "&password=" + PASSWORD);
- System.out.println("Database has been connected...");
- } catch (ClassNotFoundException ex) {
- System.err.println("加载数据库驱动发生异常!");
- // 打印错误详细信息
- ex.printStackTrace();
- } catch (SQLException e) {
- System.err.println("取得数据库连接发生异常!");
- //
- e.printStackTrace();
- }
- // 返回数据库连接
- return conn;
- }
- }
测试 MySQL 的类:
- package bzc.terry.database.mysql;
- import java.sql.Connection;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- /**
- * 一个简单的测试类
- *
- * @author Terry
- *
- */
- public class Test {
- //
- private static Connection conn = null;
- /**
- * 查询指定表中的所有信息,并打印结果
- */
- private static void findAll() {
- Statement stmt = null;
- ResultSet rs = null;
- String sql = "SELECT * FROM dept";
- //
- try {
- stmt = conn.createStatement();
- // 通过 sql 语句查新数据库中表
- // 返回相关结果集
- rs = stmt.executeQuery(sql);
- // 变量结果集
- while(rs.next()) {
- // 打印查询到的信息
- System.out.print("~ 部门号:" + rs.getInt("deptno"));
- System.out.print(" 部门名:" + rs.getString("dname"));
- System.out.println(" 部门位置:" + rs.getString("loc"));
- }
- } catch (SQLException e) {
- e.printStackTrace();
- } finally {// 关闭流和数据库连接
- try{
- if(rs != null) {
- rs.close();
- rs = null;
- }
- if(stmt != null) {
- stmt.close();
- stmt = null;
- }
- if(conn != null){
- conn.close();
- conn = null;
- System.out.println("Database has been closed...");
- }
- } catch(SQLException e) {
- e.printStackTrace();
- }
- }
- }
- /**
- *
- * 测试方法
- */
- public static void main(String[] args) {
- // 取得数据库连接
- conn = new ConnMySqlDb().getConnection();
- // 查询某个表的所有记录
- findAll();
- }
- }
Oracle 的:
- package bzc.terry.database.oracl;
- import java.sql.*;
- /**
- * 一个简单的完成连接 Oracle 数据库的例子
- * @author xIao_qiAng
- *
- */
- public class ConnOracleDb {
- private final String DBDRIVER = "oracle.jdbc.driver.OracleDriver" ;//驱动程序
- private final String DBURL = "jdbc:oracle:thin:@localhost:1521:TEST" ;//数据库地址
- private final String DBUSER = "scott" ; //数据库登录用户名
- private final String DBPASSWORD = "tiger" ; //数据库登录密码
- private Connection conn = null;
- /**
- * 完成对数据库的连接
- */
- public ConnOracleDb() {
- try {
- //加载数据库驱动程序
- Class.forName(DBDRIVER);
- } catch(Exception e) {
- System.out.println("Can't load dbdriver!-->" + e.getMessage());
- }
- try {
- //连接到指定的数据库
- conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD) ;
- } catch(Exception e) {
- System.out.println("Can't connect to the database!-->" + e.getMessage()) ;
- }
- }
- /**
- * 用来使其它类调用取得数据库连接
- * @return 数据库连接对象
- */
- public Connection getConnection() {
- return this.conn;
- }
- }
测试 Oracle 的类:
- package bzc.terry.database.oracl;
- import java.sql.*;
- public class TestConn {
- public static void main(String[] args) {
- //Connection conn = new ConnOracleDb().getConnection() ;
- //System.out.println("取得数据库连接!-->" + conn) ;
- Connection conn = null ;
- PreparedStatement pstmt = null ;
- ResultSet rs = null ;
- String sqlComm = "SELECT * FROM tb_customer" ;
- try {
- //取得数据库连接
- conn = new ConnOracleDb().getConnection() ;
- System.out.println("--------------------------------------1---") ;
- pstmt = conn.prepareStatement(sqlComm) ;
- //执行查询
- rs = pstmt.executeQuery() ;
- System.out.println("-------------------------2----------------") ;
- //遍历取出结果
- while(rs.next()) {
- System.out.println("----------------------3-------------------") ;
- System.out.print("编号:" + rs.getInt("customer_id")) ;
- System.out.print("/姓名:" + rs.getString("customer_name")) ;
- System.out.print("/性别:" + rs.getString("customer_sex")) ;
- System.out.println("/电话:" + rs.getString("customer_phone")) ;
- }
- //关闭流
- rs.close() ;
- pstmt.close() ;
- } catch(SQLException e) {
- e.printStackTrace() ;
- } catch(Exception e) {
- e.printStackTrace() ;
- } finally {//关闭数据库
- try {
- conn.close() ;
- } catch(Exception e) {
- e.printStackTrace() ;
- }
- }
- //end
- }
- }