package javabean;

import java.sql.*;

public class condb{
	private String name;
	Connection con=null;
	Statement stmt=null;
	ResultSet rs=null;
	public condb(){
		name="aaa";
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		//	rs=stmt.executeQuery("SELECT pwd from student where name='" + name + "'");
		//	System.out.println("編號\t姓名\t\t密碼\t\tEmail\n");
		//	while(rs.next())
		//	{
		//			int id=rs.getInt("id");
		//			String name=rs.getString("name");
		//			String pwd=rs.getString("pwd");
		//			String email=rs.getString("email");
		//			System.out.println("\t"+name+"\t\t"+pwd+"\t");
		//	}
	
		//	rs.close();
		//	stmt.close();
		//	con.close();
		}
		catch(Exception e)
		{
			System.out.println(e);			
		}
	}
	//執行查詢的方法
	public ResultSet executeQuery(String sql){
		rs = null;
		try
		{
			con=DriverManager.getConnection("jdbc:odbc:jdbc1");
			stmt=con.createStatement();
			rs = stmt.executeQuery(sql);
		}
		catch(Exception e)
		{
			System.out.println(e);
		}
		return rs;
	}
	public static void main(String args[]){
		condb cn=new condb();
		}
}