|
楼主 |
发表于 2013-7-16 09:34:51
|
显示全部楼层
这个是我的Action里的:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
public class Zhuchangxinxi {
public static String IP = "192.168.0.23";
public static String Kuduankou = "3306";
public static String dbUser = "root";
public static String dbPwd = "x5";
public static Connection conn ;
public static PreparedStatement temt ;
public static ResultSet rs;
static Map<String, Object> result ;
public static Map<String, Object> webjiankong(String Zhuchanghao){
result = new HashMap<String, Object>();
try {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
String url="jdbc:mysql://"+IP+":"+Kuduankou+"/xumu?useUnicode=true&characterEncoding=UTF-8";
String dbuser=dbUser;
String dbpwd=dbPwd;
conn = DriverManager.getConnection(url, dbuser, dbpwd);
if(conn!=null){
System.out.println("连接上了 !");
}
} catch (SQLException e1) {
System.out.println("连接不上!");
e1.printStackTrace();
}
try {
//temt = conn.prepareStatement("select webstate from zhuchangxinxi where zhuchangdaima = " + Zhuchanghao);
temt = conn.prepareStatement("select webstate from zhuchangxinxi where zhuchangdaima = '1000'");
rs = temt.executeQuery();
rs.next();
if(rs.getInt(1)==0){//断线!
result.put("int", 0);
return result;
}else{//在线!!!
System.out.println("查到数据库信息了 在线!");
result.put("int", 1);
return result;
}
} catch (SQLException e) {
e.printStackTrace();
}
result.put("int", 1);
return result;//默认在线!
}
} |
|