50,533
社区成员
发帖
与我相关
我的任务
分享
。。。。。。。。。
for (int j = 0; j < list_day.size(); j++) {
String day = (String) list_day.get(j);
String apwork = (String) list_apwork.get(j);
String pmwork = (String) list_pmwork.get(j);
String scheme = (String) list_scheme.get(j);
String sw = day + "#" + apwork + "#" + pmwork + "#"
+ scheme;
System.out.println(sw);
System.out.println("-------------------------");
BufferedWriter bw = new BufferedWriter(
new OutputStreamWriter(socket
.getOutputStream()));
bw.write(sw + "\r\n\r\n");
bw.flush();
}
。。。。。。。。。。。。。
package test;
import java.io.*;
import java.net.*;
public class Client {
public static void main(String args[]) {
Socket socket = null;
try {
socket = new Socket("10.10.9.222", 6666);
BufferedReader sin = new BufferedReader(new InputStreamReader(
System.in));
PrintWriter os = new PrintWriter(socket.getOutputStream());
String client_line = null;
client_line = sin.readLine();
os.println(client_line + "\r\n\r\n");
os.flush();
System.out.println("Client:" + client_line);
// 从服务端程序接收数据
while (true) {
InputStream ips = socket.getInputStream();
InputStreamReader ipsr = new InputStreamReader(ips);
BufferedReader br = new BufferedReader(ipsr);
String s = null;
s = br.readLine();
while (!s.equals("bye")) {
String str[] = s.split("#");
String day = str[0];
String apwork = str[1];
String pmwork = str[2];
String scheme = str[3];
System.out.println("day:" + day);
System.out.println("apwork:" + apwork);
System.out.println("pmwork:" + pmwork);
System.out.println("scheme:" + scheme);
}
System.out.println("Server:" + s);
System.out.println("------------------------------");
}
} catch (UnknownHostException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
socket.close();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// 向服务端程序发送数据
// OutputStream ops = socket.getOutputStream();
// OutputStreamWriter opsw = new OutputStreamWriter(ops);
// BufferedWriter bw = new BufferedWriter(opsw);
// bw.write("yy88\r\n\r\n");
// bw.flush();
}
}
package test;
import java.io.*;
import java.net.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.io.UnsupportedEncodingException;
import java.security.MessageDigest;
import java.security.NoSuchAlgorithmException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;
import sun.misc.BASE64Encoder;
public class Server {
List list_day = new ArrayList();
List list_apwork = new ArrayList();
List list_pmwork = new ArrayList();
List list_scheme = new ArrayList();
public void login() {
ServerSocket server = null;
Socket socket = null;
String employeeid = null;
try {
server = new ServerSocket(6666);
while (true) {
employeeid = null;
socket = server.accept();
String client_line = null;
BufferedReader br = new BufferedReader(new InputStreamReader(
socket.getInputStream()));
client_line = br.readLine();
String server_line = null;
String employee_name = null;
boolean bb = false;
System.out.println("client_line:" + client_line);
String str[] = client_line.split("#");
String name = str[0];
String pwd = str[1];
System.out.println("-----------------------------");
System.out.println(name);
System.out.println(pwd);
System.out.println("-----------------------------");
String pwd_md5 = null;
try {
MessageDigest md5 = MessageDigest.getInstance("MD5");
BASE64Encoder base64en = new BASE64Encoder();
pwd_md5 = base64en
.encode(md5.digest(pwd.getBytes("utf-8")));
} catch (NoSuchAlgorithmException e1) {
e1.printStackTrace();
} catch (UnsupportedEncodingException e1) {
e1.printStackTrace();
}
System.out.println(pwd_md5);
try {
DB1 db = new DB1();
ResultSet rst = db
.qu("select * from t_acl_user where username = '"
+ name + "'");
while (rst.next()) {
employeeid = rst.getString("employeeid");
System.out.println(employeeid);
server_line = rst.getString("password");
System.out.println("server_line:" + server_line);
bb = true;
}
rst.close();
db.close();
} catch (SQLException e) {
e.printStackTrace();
}
System.out.println(employeeid);
System.out.println("-----------------------");
if (bb == false) {
BufferedWriter bw = new BufferedWriter(
new OutputStreamWriter(socket.getOutputStream()));
bw.write("查无此号" + "\r\n\r\n");
bw.flush();
} else if (bb == true) {
if (pwd_md5.equals(server_line)) {
Date now_date = new Date();
int now_year = now_date.getYear() + 1900;
int now_month = now_date.getMonth();
String ss = now_year + "-" + now_month;
DB1 db = new DB1();
ResultSet rst;
try {
rst = db
.qu("select apwork,pmwork,scheme,day(commentdate) as day from t_day_comment where employeeid ='"
+ employeeid
+ "' and cast(year(commentdate) as varchar) + "
+ "'-' + cast(month(commentdate) as varchar) = '"
+ ss + "' order by day");
list_day = new ArrayList();
list_apwork = new ArrayList();
list_pmwork = new ArrayList();
list_scheme = new ArrayList();
while (rst.next()) {
list_day.add(rst.getString("day"));
list_apwork.add(rst.getString("apwork"));
list_pmwork.add(rst.getString("pmwork"));
list_scheme.add(rst.getString("scheme"));
}
} catch (SQLException e) {
e.printStackTrace();
}
BufferedWriter bw = new BufferedWriter(
new OutputStreamWriter(socket
.getOutputStream()));
for (int j = 0; j < list_day.size(); j++) {
String day = (String) list_day.get(j);
String apwork = (String) list_apwork.get(j);
String pmwork = (String) list_pmwork.get(j);
String scheme = (String) list_scheme.get(j);
String sw = day + "#" + apwork + "#" + pmwork + "#"
+ scheme;
System.out.println(sw);
System.out.println("-------------------------");
bw.write(sw + "\r\n\r\n");
bw.flush();
}
bw.write("bye" + "\r\n\r\n");
bw.flush();
} else if (!pwd_md5.equals(server_line)) {
BufferedWriter bw = new BufferedWriter(
new OutputStreamWriter(socket.getOutputStream()));
bw.write("密码错误" + "\r\n\r\n");
bw.flush();
}
}
}
} catch (IOException e) {
e.printStackTrace();
}
try {
socket.close();
server.close();
} catch (IOException e) {
e.printStackTrace();
}
}
public static void main(String args[]) {
Server server = new Server();
server.login();
}
}
class DB1 {
Connection con;
Statement stt;
public void begin() throws SQLException {
if (con != null || stt != null) {
this.close();
}
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection(
"jdbc:sqlserver://10.10.1.188:1433; DatabaseName=znoa",
"sa", "soft8099");
stt = con.createStatement();
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e1) {
e1.printStackTrace();
}
}
public ResultSet qu(String sql) throws SQLException {
this.begin();
return stt.executeQuery(sql);
}
public boolean cun(String sql) throws SQLException {
this.begin();
return stt.execute(sql);
}
public int update(String sql) throws SQLException {
this.begin();
return stt.executeUpdate(sql);
}
public void close() throws SQLException {
stt.close();
con.close();
}
}