package ConDb;
import java.sql.*;

public class  ConDb{
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:class";
Connection conn = null;
ResultSet rs = null;
Timestamp ts;
String name,sex,birthday,qq,phone,email,work,addr,postcode,other;
public String getname(){
	return name;
}
public String getsex(){
	return sex;
}
public String getqq(){
	return qq;
}
public String getphone(){
	return phone;
}
public String getwork(){
	return work;
}
public String getaddr(){
	return addr;
}
public String getpostcode(){
	return postcode;
}
public String getother(){
	return other;
}
public String getbirth(){
	String str;
	long lms=ts.getTime();
	Date date=new Date(lms);
	str=date.toString();
	return str;
}
public String getemail(){
	return email;
}
public ConDb() {
try {
Class.forName(sDBDriver); 
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("bbsreg(): " + e.getMessage());
}
}

public ResultSet execute(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr); 
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
} 
catch(SQLException ex) { 
System.err.println("aq.executeQuery: " + ex.getMessage());
System.err.println("aq.executeQuerystrSQL: " + sql);
}
return rs;
}
public void exec(String sql) { 
	rs = null;
	try {
	conn = DriverManager.getConnection(sConnStr); 
	Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
	rs = stmt.executeQuery(sql);
	if(rs.next()){
		name=rs.getString("name");
		sex=rs.getString("sex");
		ts=rs.getTimestamp("birth");
		qq=rs.getString("qq");
		email=rs.getString("email");
		phone=rs.getString("phone");
		work=rs.getString("work");
		addr=rs.getString("addr");
		postcode=rs.getString("postcode");
		other=rs.getString("other");
	}
	} 
	catch(SQLException ex) { 
	System.err.println("aq.executeQuery: " + ex.getMessage());
	System.err.println("aq.executeQuerystrSQL: " + sql);
	}
	
	}
public String makepage(ResultSet testrs,String url,int page,int pagesize) {
int allpage=0;
String str="";  
try {
testrs.last();
allpage=testrs.getRow();
if (allpage>0) 
{ testrs.absolute((page-1) * pagesize +1);
allpage=(allpage+pagesize-1) / pagesize; 
str += "第 "+page+" 頁  共 "+allpage + " 頁";  
if(page>1)   
str+=" <A href="+url+"page="+ 1+">第一頁</A> ";   
else  
str+=" 第一頁 ";  
if(page>1)   
str+=" <A href="+url+"page="+(page-1)+">上一頁</A> ";   
else  
str+=" 上一頁 ";  
if(page <allpage)   
str+=" <A href="+url+"page="+(page+1)+">下一頁</A> ";   
else   
str+=" 下一頁 ";  
if(page <allpage)   
str+=" <A href="+url+"page="+allpage+">最后頁</A> ";   
else  
str+=" 最后頁 ";   
}
else 
str="zero";
} 
catch(Exception ex) { 
System.err.println("aq.executeQuery: " + ex.getMessage());
System.err.println("aq.executeQuerystrSQL: " + allpage);
} 
return str;
}
public void Update(String sql) {
try {
conn = DriverManager.getConnection(sConnStr); 
Statement stmt = conn.createStatement();
stmt.executeUpdate(sql);
} 
catch(SQLException ex) { 
System.err.println("aq.executeUpdate: " + ex.getMessage());
System.err.println("aq.executeUpadatestrSQL: " + sql);
}
}

public void close() {
try {
conn.close(); 
} 
catch(SQLException ex) { 
System.err.println("aq.executeUpdate: " + ex.getMessage());
}
}
}