database.java

来自「用JAVA实现串口GSM发信息」· Java 代码 · 共 80 行

package com;

/*
 Jdbc_Odbc连接Sql2000
 */

import java.sql.*;

import javax.swing.JOptionPane;

public class DataBase {
	Connection conn=null;;
	Statement stmt=null;;
	ResultSet rs=null;;	
	
	public DataBase(){
		try {
			//odbc
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			String url = "jdbc:odbc:MySql2000"; // 数据源名称
			
			//jdbc
			//Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); 
			//String url="jdbc:microsoft:sqlserver://219.222.170.52:1433;DatabaseName=MySql2000";
			
			String user = "sa";
			String password = "sa";
			conn = DriverManager.getConnection(url, user, password);
			stmt = conn.createStatement();
			
			System.out.println("Connection OK!");
		} catch (Exception e) {
			System.out.println("Err,连接数据库出错!");
			JOptionPane.showMessageDialog(null, "连接数据库出错!");
			
			e.printStackTrace();
		}
	}
	
	public Statement getStatement() {
		return stmt;
	}

	public Connection getConnection() {
		return conn;
	}
	
	public void close() throws SQLException {
		if ( stmt != null )
		{
			stmt.close();
			stmt = null;
		}
		conn.close();
		conn = null;
	}
	
	public static void main(String[] args) {		
		Statement stmt;
		ResultSet rs;
		String sql;
		DataBase Test=new DataBase();		
		
		try {
			stmt=Test.getStatement();
			sql = "select * from test";
			rs = stmt.executeQuery(sql);
			while (rs.next()) {
				System.out.print("Id: " + rs.getString(1));
				System.out.println("\tName: " + rs.getString(2));
			}
			Test.close();
			System.out.println("OK!");
		} catch (Exception e) {
			System.out.println("Err!");
			e.printStackTrace();
		}
	}
}