22,207
社区成员
发帖
与我相关
我的任务
分享
CSocket t1 = new CSocket();
String str = t1.one("select sum(bsalary) from worker");
public String one(String s) throws UnknownHostException, IOException{
Socket sock = new Socket(ip, duan);
PrintStream out = new PrintStream(sock.getOutputStream());
String st="8#"+s;
out.println(st);
BufferedReader in = new BufferedReader(new InputStreamReader(sock.getInputStream()));
String s1 = in.readLine();
sock.close();
out.close();
return s1;
}
else if(p==8){
System.out.println("部件查询");
ResultSet s = sk.executeQuery(sql[1]);
st=null;
PrintStream out = new PrintStream(socket.getOutputStream());
s.next();//只遍历一行
st=""+s.getInt(1);
out.println(st);
out.close();
}
界面启动...
dnode=员工基本信息管理
dnode=添加员工信息
添加员工信息
dnode=删除员工
删除员工
dnode=所有员工信息
所有员工信息
dnode=车间管理
dnode=添加车间信息
添加车间信息
dnode=修改车间信息
修改车间信息
dnode=删除车间信息
删除车间信息
dnode=查询车间信息
查询车间信息
dnode=生产部件管理
dnode=添加生产部件信息
添加生产部件信息
dnode=修改生产部件信息
修改生产部件信息
dnode=删除生产部件信息
删除生产部件信息
dnode=查询生产部件信息
查询生产部件信息
java.net.SocketException: Connection reset
at java.net.SocketInputStream.read(SocketInputStream.java:168)
at sun.nio.cs.StreamDecoder.readBytes(StreamDecoder.java:264)
at sun.nio.cs.StreamDecoder.implRead(StreamDecoder.java:306)
at sun.nio.cs.StreamDecoder.read(StreamDecoder.java:158)
at java.io.InputStreamReader.read(InputStreamReader.java:167)
at java.io.BufferedReader.fill(BufferedReader.java:136)
at java.io.BufferedReader.readLine(BufferedReader.java:299)
at java.io.BufferedReader.readLine(BufferedReader.java:362)
at lab.CSocket.one(CSocket.java:271)
at lab.Node34Panel.downInit(Node34Panel.java:98)
at lab.Node34Panel.<init>(Node34Panel.java:42)
at lab.HrMain.valueChanged(HrMain.java:244)
at javax.swing.JTree.fireValueChanged(JTree.java:2823)
at javax.swing.JTree$TreeSelectionRedirector.valueChanged(JTree.java:3194)
at javax.swing.tree.DefaultTreeSelectionModel.fireValueChanged(DefaultTreeSelectionModel.java:629)
at javax.swing.tree.DefaultTreeSelectionModel.notifyPathChange(DefaultTreeSelectionModel.java:1078)
at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPaths(DefaultTreeSelectionModel.java:287)
at javax.swing.tree.DefaultTreeSelectionModel.setSelectionPath(DefaultTreeSelectionModel.java:170)
at javax.swing.JTree.setSelectionPath(JTree.java:1598)
CSocket t1 = new CSocket();
String str = t1.one("select TOP 1 cname from component
ORDER BY cvalues DESC");
还是不行
我下午去问问老师 谢了CSocket t1 = new CSocket();
String str = t1.one("select cname from component t where cvalues=(select max(cvalues) from component where cname=t.cname)");
出错了select cname from component t where cvalues=(select max(cvalues) from component where cname=t.cname)