@RequestMapping(method = RequestMethod.POST)
public @ResponseBody DataShop getShopInJSON(
@RequestParam("lictype") String lictype, HttpSession session) throws Exception {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
DataShop dataShop = new DataShop();
List list = new ArrayList();
List listX = new ArrayList();
String s_drvschool = session.getAttribute("user").toString();
try {
Class.forName("org.postgresql.Driver").newInstance();
} catch (Exception e) {
System.out.print(e.getMessage());
}
DBInfo connstr = new DBInfo();
String url = connstr.getUrl();
String user = connstr.getUser();
String password = connstr.getPassword();
try {
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement();
int i_num_tj = 0;
String sql =
"select count(1) as num_tj " + " from work.qt_cont WHERE lictype='" + lictype + "'";
rs = stmt.executeQuery(sql);
while (rs.next()) {
i_num_tj = rs.getInt(1);
if (i_num_tj == 0 || rs.getString(1) == null) {
dataShop.setSuccess(true);
} else {
dataShop.setSuccess(false);
}
}
} catch (SQLException e) {
System.out.print(e.getMessage());
} finally {
try {
if (rs != null) rs.close();
if (stmt != null) stmt.close();
if (conn != null) conn.close();
} catch (SQLException e) {
System.out.print(e.getMessage());
}
}
// dataShop.setList(list);
return dataShop;
}
@RequestMapping(method = RequestMethod.POST)
public @ResponseBody DataShop getShopInJSON(
// @PathVariable String user_id,
@RequestParam("id") Integer id) throws Exception {
DataShop dataShop = new DataShop();
Connection conn = null;
PreparedStatement pst = null;
try {
Class.forName("org.postgresql.Driver").newInstance();
} catch (Exception e) {
System.out.print(e.getMessage());
}
DBInfo connstr = new DBInfo();
String url = connstr.getUrl();
String user = connstr.getUser();
String password = connstr.getPassword();
try {
conn = DriverManager.getConnection(url, user, password);
String sql = "delete from work.users where id = ?";
pst = conn.prepareStatement(sql);
pst.setInt(1, id);
pst.executeUpdate();
dataShop.setSuccess(true);
} catch (SQLException e) {
System.out.print(e.getMessage());
} finally {
try {
if (pst != null) pst.close();
if (conn != null) conn.close();
} catch (SQLException e) {
System.out.print(e.getMessage());
}
}
// dataShop.setName(user_id);
return dataShop;
}
@RequestMapping(method = RequestMethod.POST)
public @ResponseBody DataShop getShopInJSON(
@RequestParam("id") Integer id,
@RequestParam("name") String name,
@RequestParam("sex") String sex,
@RequestParam("card") String card,
@RequestParam("address") String address,
@RequestParam("lictype") String lictype,
@RequestParam("licdt") String licdt,
@RequestParam("licmd") String licmd,
@RequestParam("status") String status,
@RequestParam("auditdt") String auditdt,
@RequestParam("auditps") String auditps,
@RequestParam("remark") String remark)
throws Exception {
DataShop dataShop = new DataShop();
dataShop.setSuccess(true);
Connection conn = null;
PreparedStatement pst = null;
try {
Class.forName("org.postgresql.Driver").newInstance();
} catch (Exception e) {
System.out.print(e.getMessage());
}
DBInfo connstr = new DBInfo();
String url = connstr.getUrl();
String user = connstr.getUser();
String password = connstr.getPassword();
try {
conn = DriverManager.getConnection(url, user, password);
String sql =
"update work.examinees set "
+ "name=?, sex=?, card=?, address=?, lictype=?, licdt=?, licmd=?,status=?, "
+ " auditdt=?,auditps=?, remark=?"
+ "where id = ?";
pst = conn.prepareStatement(sql);
pst.setString(1, name);
pst.setString(2, sex);
pst.setString(3, card);
pst.setString(4, address);
pst.setString(5, lictype);
java.sql.Date sql_licdt = null;
if (licdt != null && licdt.length() > 2) sql_licdt = java.sql.Date.valueOf(licdt);
pst.setDate(6, sql_licdt);
pst.setString(7, licmd);
pst.setString(8, status);
java.sql.Date sql_auditdt = null;
if (auditdt != null && auditdt.length() > 2) sql_auditdt = java.sql.Date.valueOf(auditdt);
pst.setDate(9, sql_auditdt);
pst.setString(10, auditps);
pst.setString(11, remark);
pst.setInt(12, id);
pst.executeUpdate();
dataShop.setSuccess(true);
} catch (SQLException e) {
System.out.print(e.getMessage());
} finally {
try {
if (pst != null) pst.close();
if (conn != null) conn.close();
} catch (SQLException e) {
System.out.print(e.getMessage());
}
}
return dataShop;
}