50,530
社区成员
发帖
与我相关
我的任务
分享
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.applet.Applet;
public class Server {
public static void main(String args[]) {
ServerSocket server = null;
Socket socket = null;
try {
server = new ServerSocket(4700);
socket = server.accept();
String client_line = null;
BufferedReader br = new BufferedReader(new InputStreamReader(socket
.getInputStream()));
client_line = br.readLine();
System.out.println("Client:" + client_line);
String server_line = null;
try {
DB1 db = new DB1();
ResultSet rst = db
.qu("select employeeid from t_acl_user where username = '"
+ client_line + "'");
while (rst.next()) {
server_line = rst.getString("employeeid");
}
rst.close();
db.closs();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
BufferedWriter bw = new BufferedWriter(new OutputStreamWriter(
socket.getOutputStream()));
if(server_line == null){
bw.write("null\r\n\r\n");
bw.flush();
System.out.println("Server: null");
}else{
bw.write(server_line + "\r\n\r\n");
bw.flush();
System.out.println("Server:" + server_line);
}
socket.close(); // 关闭Socket
server.close(); // 关闭ServerSocket
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
class DB1 {
Connection con;
Statement stt;
public void begin() throws SQLException {
if (con != null || stt != null) {
this.closs();
}
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) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e1) {
// TODO Auto-generated catch block
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 closs() throws SQLException {
stt.close();
con.close();
}
}