package?com.xasxt.bookclient.common;

import?java.io.BufferedReader;
import?java.io.BufferedWriter;
import?java.io.IOException;
import?java.io.InputStreamReader;
import?java.io.OutputStreamWriter;
import?java.net.Socket;
import?java.net.UnknownHostException;
import?java.sql.ResultSet;
import?java.sql.SQLException;

import?com.xasxt.bookmgr.dao.DBManager;
import?com.xasxt.bookmgr.entities.User;

public?class?NetUtil?{
	
	public?static?int?login（String?nameString?pass）{
		String?sql?=?“select?state?from?reader?where?readername?=?‘“?+?name?+?“‘?and?password?=?‘“?+?pass?+?“‘“;
		ResultSet?rs?=?DBManager.executeQuery（sql?DBManager.getConnection（））;
		try?{
			if（rs.next（））{
				if（rs.getBoolean（“state“）?==?true）{
					return?0;
				}else{
					return?2;
				}
			}else{
				return?1;
			}
		}?catch?（Exception?e）?{
			throw?new?RuntimeException（“數(shù)據(jù)庫(kù)查詢錯(cuò)誤！“e）;
		}
		
	}
	public?static?String?getTypes（）{
		StringBuilder?sb?=?new?StringBuilder（）;
		String?sql?=?“select?*?from?booktype“;
		try?{
			ResultSet?rs?=?DBManager.executeQuery（sql?DBManager.getConnection（））;
			while（rs.next（））{
				sb.append（rs.getString（“typename“）?+?““）;
			}
		}?catch?（Exception?e）?{
			throw?new?RuntimeException（“數(shù)據(jù)庫(kù)查詢出錯(cuò)！“e）;
		}
		if（sb.length（）?!=?0）{
			sb.deleteCharAt（sb.length（）?-?1）;
		}
		return?sb.toString（）;
		
	}
	public?static?String?getBooks（String?type）{
		StringBuilder?sb?=?new?StringBuilder（）;
		String?sql?=?“select?*?from?book?where?type?=?‘“?+?type?+“‘“;
		ResultSet?rs?=?DBManager.executeQuery（sql?DBManager.getConnection（））;
		try?{
			while（rs.next（））{
				sb.append（rs.getInt（“id“）?+?““）;
				sb.append（rs.getString（“name“）?+?““）;
				sb.append（rs.getString（“type“）?+?““）;
				sb.append（rs.getString（“author“）?+?““）;
				sb.append（rs.getString（“publisher“）?+?““）;
				sb.append（rs.getDouble（“price“）?+?““）;
				sb.append（（rs.getString（“imagePath“）?==?null?“default.png“:rs.getString（“imagePath“））?+?““）;
			}
		}?catch?（Exception?e）?{
			throw?new?RuntimeException（“數(shù)據(jù)庫(kù)查詢出錯(cuò)！“e）;
		}
		if（sb.length（）?!=?0）{
			sb.deleteCharAt（sb.length（）?-?1）;
			sb.deleteCharAt（sb.length（）?-?1）;
		}
		return?sb.toString（）;
	}
	public?static?String?getBook（String?id）?{
		StringBuilder?sb?=?new?StringBuilder（）;
		String?sql?=?“select?*?from?book?where?id?=?“?+?Integer.parseInt（id）;
		ResultSet?rs?=?DBManager.executeQuery（sql?DBManager.getConnection（））;
		try?{
			if（rs.next（））{
				sb.append（rs.getInt（“id“）?+?““）;
				sb.append（rs.getString（“name“）?+?““）;
				sb.append（rs.getString（“type“）?+?““）;
				sb.append（rs.getString（“author“）?+?““）;
				sb.append（rs.getString（“publisher“）?+?““）;
				sb.append（rs.getDouble（“price“）?+?““）;
				sb.append（rs.getString（“imagePath“）?==?null?“default.png“:rs.getString（“imagePath“））;
			}
		}?catch?（Exception?e）?{
			throw?new?RuntimeException（“數(shù)據(jù)庫(kù)查詢出錯(cuò)！“e）;
		}
		return?sb.toString（）;
	}
	public?static?int?modifyPassword（String?userNameS

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件????????547??2012-02-16?12:46??cs\BookClient\.classpath

?????文件????????386??2009-02-11?11:49??cs\BookClient\.project

?????文件????????629??2009-02-11?11:49??cs\BookClient\.settings\org.eclipse.jdt.core.prefs

?????文件???????4815??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\common\NetUtil.class

?????文件????????671??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\startup\Start.class

?????文件???????2446??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\BookInfoframe$1.class

?????文件???????4432??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\BookInfoframe.class

?????文件????????768??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Loginframe$1.class

?????文件???????2148??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Loginframe$2.class

?????文件???????1442??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Loginframe$3.class

?????文件???????4228??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Loginframe.class

?????文件???????1122??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Mainframe$1.class

?????文件???????2755??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Mainframe$10.class

?????文件???????2686??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Mainframe$11.class

?????文件???????2564??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Mainframe$12.class

?????文件???????1467??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Mainframe$13.class

?????文件???????1074??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Mainframe$2.class

?????文件????????771??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Mainframe$3.class

?????文件???????2726??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Mainframe$4.class

?????文件???????2882??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Mainframe$5.class

?????文件????????876??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Mainframe$6.class

?????文件???????1231??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Mainframe$7.class

?????文件???????2846??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Mainframe$8.class

?????文件???????2313??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Mainframe$9.class

?????文件??????12401??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Mainframe.class

?????文件????????792??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Passwordframe$1.class

?????文件???????2087??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Passwordframe$2.class

?????文件???????3232??2012-05-08?17:28??cs\BookClient\bin\com\xasxt\bookclient\ui\Passwordframe.class

?????文件????1138091??2012-02-20?21:19??cs\BookClient\BookClient.jar

?????文件????5242880??2009-02-13?17:45??cs\BookClient\bookdatabase_data.mdf

............此處省略209個(gè)文件信息