{
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;
Statementstmt=null;
ResultSetrs;
DataOutputStream out=null;
DataInputStreamin=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;
}
}
}
}
java简单的借书系统HashMap借书用java的源代码的常用方法
map的存储和修改方式 map.put(key, value);
map是否包含某个元素map.containsKey(key);
map某个key的value值map.get(key);
参考代码
import java.util.HashMap;
public class BookTest {
static HashMapString, Integer map=new HashMapString, Integer();
static{//初始化图书信息
map.put("三国志", 8);
map.put("红楼梦", 0);
map.put("西游记", 15);
}
public static void main(String[] args) {//main方法
jieShu("水浒");
jieShu("三国志");
huanShu("三国志");
jieShu("红楼梦");
- java查询数组中是否包含某一个值 javamongodb数组查询
- redis实战电子书 redisjava书籍
- javaredis集群 javaredis列队
- Redis队列排队 redis队列java
- java mongodb aggregate mongodb的教程java
- redis实现秒杀功能java redis和mq实现秒杀
- redis队列实现秒杀java redis推时队列
- java redis面试 javaredis试题
- spring监听redis队列 java中redis监听
- java中redis javaredis异常
