conndb.java

来自「一个用JAVA实现的彩票20选5的小程序,大家可以看看买彩票中的机率哦,仅供参考」· Java 代码 · 共 47 行

package cn.vote.lucky;

//��ݿ����
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.sql.DriverManager;


public class ConnDb{
	public static Connection conn=null;
	public static Statement stmt=null;
    public static String driver="net.sourceforge.jtds.jdbc.Driver";
    public static String url="jdbc:jtds:sqlserver://localhost:1433/vote";
    public static String user="sa";
	public static String pass="a";
	// 连接��
	public static void initConn()throws Exception{
		Class.forName(driver);
		conn=DriverManager.getConnection(url,user,pass);
		stmt=conn.createStatement();
	}
	// ��查询
	public static ResultSet executeSelect(String sql)throws Exception{
		initConn();
		return stmt.executeQuery(sql);
	}
	// statement
	public static PreparedStatement pstmt(String sql)throws Exception{
		initConn();
		return conn.prepareStatement(sql);
	}
	
	// 关闭�
	public static void closeDb()throws Exception{
		conn.close();
	}
	public static void main(String[] args)throws Exception{
		ResultSet rs=ConnDb.executeSelect("select * from vote");
		while(rs.next()){
			System.out.print(rs.getString(1));
		}
	}

}