alljdbc.java

主要是一个中央电视台节目点播程序,完成了一些简单的功能

package com.cctv1.spe.conn;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Alljdbc { // 所有数据JDBC

	private Connection conn = null;

	private String driver = "oracle.jdbc.driver.OracleDriver";

	private String url = "jdbc:oracle:thin:@localhost:1521:TB";

	private String name = "beacon";

	private String pass = "bingo";

	public Connection Getlink() {

		try {
			
			Class.forName(driver);// 加载数据驱动
			
			conn = DriverManager.getConnection(url, name, pass);
			
			System.out.println("conn is ok!");
		} catch (ClassNotFoundException e) {
			
			System.out.println("conn no open!");
			
			e.printStackTrace();
			
		} catch (SQLException e) {
			
			e.printStackTrace();
		}

		return conn;

	}

}