package news;

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

public class DB {

	Connection connect = null;
	ResultSet rs = null;
	public DB() {
		try {
			Class.forName("org.gjt.mm.mysql.Driver"); 	//璁劇疆椹卞姩紼嬪簭綾誨瀷		
		}
		catch(java.lang.ClassNotFoundException e) {
			e.printStackTrace();
		}
	}
	
	public ResultSet executeQuery(String sql) {
		try {
			connect = DriverManager.getConnection("jdbc:mysql://localhost/test", "root", "zgy01");  //錕斤拷b錕斤拷錕斤拷菘錕斤拷錕斤拷錕斤拷錕絣錕斤拷
			Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
			rs = stmt.executeQuery(sql);//鎵ц