图书查询系统.txt

图书查询系统图书查询系统

import java.io.*; 
import java.net.*; 
import java.sql.*; 
import java.util.StringTokenizer; 
public class DatabaseServer 
{ 
public static void main(String args[]) 
{ 
ServerSocket server=null; 
Server_thread thread; 
Socket you=null; 
while(true) 
{ 
try 
{ 
server=new ServerSocket(6666); 
} 
catch(IOException e1) 
{ 
System.out.println("正在监听"); 
} 
try 
{ 
you=server.accept(); 
} 
catch (IOException e) 
{ 
} 
if(you!=null) 
{ 
new Server_thread(you).start(); 
} 
else {continue;} 
} 
} 
} 
class Server_thread extends Thread 
{ 
Socket socket; 
Connection con=null; 
Statement stmt=null; 
ResultSet rs; 
DataOutputStream out=null; 
DataInputStream in=null; 
String s=null; 
int number=0; 
Server_thread(Socket t) 
{ 
socket=t; 
try { 
in=new DataInputStream(socket.getInputStream()); 
out=new DataOutputStream(socket.getOutputStream()); 
} 
catch (IOException e) 
{ 
} 
try { 
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
} 
catch(ClassNotFoundException e){} 
try{ 
con=DriverManager.getConnection("jdbc:odbc:moon","",""); 
stmt=con.createStatement(); 
} 
catch(SQLException ee) {} 
} 
public void run() 
{ 
while(true) 
{ 
try{ 
s=in.readUTF(); 
System.out.println(s); 
String sqlCondition=null; 
String 查询内容="",查询范畴="",查询条件=""; 
StringTokenizer fenxi=new StringTokenizer(s,":"); 
if(fenxi.hasMoreTokens()) 
{ 
查询内容=fenxi.nextToken(); 
} 
if(fenxi.hasMoreTokens()) 
{ 
查询范畴=fenxi.nextToken(); 
} 
if(fenxi.hasMoreTokens()) 
{ 
查询条件=fenxi.nextToken(); 
} 
if(查询条件.equals("完全一致")) 
{ 
sqlCondition= 
"SELECT * FROM bookform WHERE "+查询范畴+" = "+"′"+查询内容+"′ "; 
} 
else if(查询条件.equals("前方一致")) 
{ 
sqlCondition= 
"SELECT * FROM bookform WHERE "+查询范畴+" LIKE "+"′"+查询内容+"%′ "; 
} 
else if(查询条件.equals("后方一致")) 
{ 
sqlCondition= 
"SELECT * FROM bookform WHERE "+查询范畴+" LIKE "+"′%"+查询内容+"′ "; 
} 
else if(查询条件.equals("中间包含")) 
{ 
sqlCondition= 
"SELECT * FROM bookform WHERE "+查询范畴+" LIKE "+"′%"+查询内容+"%′ "; 
} 
try{ 

rs=stmt.executeQuery(sqlCondition); 
number=0; 
while(rs.next()) 
{ 
number++; 
String 书名=rs.getString("书名"); 
String 作者=rs.getString("作者"); 
String 出版社=rs.getString("出版社"); 
String 价格=rs.getString("价格"); 
Date 日期=rs.getDate("日期"); 
out.writeUTF("\n"+number+" "+书名+" , "+作者+","+出版社+","+价格+ 
","+日期); 
} 
if(number==0) 
{ 
out.writeUTF("没有查询到任何记录\n"); 
} 

} 
catch(SQLException ee) {} 
} 
catch (IOException e) 
{ 
try 
{ 
socket.close(); 
con.close(); 
} 
catch(Exception eee) 
{ 
} 

System.out.println("客户离开了"); 
break; 
} 

} 
} 
} 


------------------------------------------- 

import java.io.*; 
import java.net.*; 
import java.sql.*; 
import java.util.StringTokenizer; 
public class DatabaseServer 
{ 
public static void main(String args[]) 
{ 
ServerSocket server=null; 
Server_thread thread; 
Socket you=null; 
while(true) 
{ 
try 
{ 
server=new ServerSocket(6666); 
} 
catch(IOException e1) 
{ 
System.out.println("正在监听"); 
} 
try 
{ 
you=server.accept(); 
} 
catch (IOException e) 
{ 
} 
if(you!=null) 
{ 
new Server_thread(you).start(); 
} 
else {continue;} 
} 
} 
} 
class Server_thread extends Thread 
{ 
Socket socket; 
Connection con=null; 
Statement stmt=null; 
ResultSet rs; 
DataOutputStream out=null; 
DataInputStream in=null; 
String s=null; 
int number=0; 
Server_thread(Socket t) 
{ 
socket=t; 
try { 
in=new DataInputStream(socket.getInputStream()); 
out=new DataOutputStream(socket.getOutputStream()); 
} 
catch (IOException e) 
{ 
} 
try { 
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
} 
catch(ClassNotFoundException e){} 
try{ 
con=DriverManager.getConnection("jdbc:odbc:moon","",""); 
stmt=con.createStatement(); 
} 
catch(SQLException ee) {} 
} 
public void run() 
{ 
while(true) 
{ 
try{ 
s=in.readUTF(); 
System.out.println(s); 
String sqlCondition=null; 
String 查询内容="",查询范畴="",查询条件=""; 
StringTokenizer fenxi=new StringTokenizer(s,":"); 
if(fenxi.hasMoreTokens()) 
{ 
查询内容=fenxi.nextToken(); 
} 
if(fenxi.hasMoreTokens()) 
{ 
查询范畴=fenxi.nextToken(); 
} 
if(fenxi.hasMoreTokens()) 
{ 
查询条件=fenxi.nextToken(); 
} 
if(查询条件.equals("完全一致")) 
{ 
sqlCondition= 
"SELECT * FROM bookform WHERE "+查询范畴+" = "+"′"+查询内容+"′ "; 
} 
else if(查询条件.equals("前方一致")) 
{ 
sqlCondition= 
"SELECT * FROM bookform WHERE "+查询范畴+" LIKE "+"′"+查询内容+"%′ "; 
} 
else if(查询条件.equals("后方一致")) 
{ 
sqlCondition= 
"SELECT * FROM bookform WHERE "+查询范畴+" LIKE "+"′%"+查询内容+"′ "; 
} 
else if(查询条件.equals("中间包含")) 
{ 
sqlCondition= 
"SELECT * FROM bookform WHERE "+查询范畴+" LIKE "+"′%"+查询内容+"%′ "; 
} 
try{ 

rs=stmt.executeQuery(sqlCondition); 
number=0; 
while(rs.next()) 
{ 
number++; 
String 书名=rs.getString("书名"); 
String 作者=rs.getString("作者"); 
String 出版社=rs.getString("出版社"); 
String 价格=rs.getString("价格"); 
Date 日期=rs.getDate("日期"); 
out.writeUTF("\n"+number+" "+书名+" , "+作者+","+出版社+","+价格+ 
","+日期); 
} 
if(number==0) 
{ 
out.writeUTF("没有查询到任何记录\n"); 
} 

} 
catch(SQLException ee) {} 

} 
catch (IOException e) 
{ 
try 
{ 
socket.close(); 
con.close(); 
} 
catch(Exception eee) 
{ 
} 

System.out.println("客户离开了"); 
break; 
} 

} 
} 
}