package denglu;

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

public class LinkDataBast {
		private String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; 
		private String dbURL = "jdbc:sqlserver://202.115.80.180:2433;"+"DatabaseName=JY06;user=jy06;password=jy06;";
		private Connection dbConn;
		public ResultSet rs = null ;
		private Statement stmt;
		LinkDataBast(String sentence)//構造方法 
		{
			try{
				try{
						Class.forName(driverName);
				}catch(ClassNotFoundException a)
				{
						System.out.println("數據庫異常11!");
				}
						dbConn = DriverManager.getConnection(dbURL); 
						stmt = dbConn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
						rs = stmt.executeQuery(sentence);
						rs.next();
			}catch(SQLException eee)
			{
						System.out.println("數據庫異常12!");
			}
		}
}