db.java

来自「Eclipse开发入门与项目实践+源代码,是邮电出版社书籍配套源码」· Java 代码 · 共 26 行

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);//鎵ц