更新一个的操作:
package jdbc.json;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import net.sf.json.JSONObject;
import sun.dc.pr.PRError;
public class Json {
static String json_doctor="{\"alice\":{\"doctor_id\":1001,\"doctor_pwd\":\"111\"},\"tom\":{\"doctor_id\":1002,\"doctor_pwd\":\"111\"},\"cndy\":{\"doctor_id\":1003,\"doctor_pwd\":\"111\"}}";
public static void main(String[] args) {
JSONdoctor();
JDBCc();
}
public static JSONObject JSONdoctor(){
// System.out.println("json字符串--------------------");
// System.out.println(json_doctor);
//将json字符串转为json对象。
JSONObject msg = JSONObject.fromObject(json_doctor);
// System.out.println("json对象:"+msg);
// System.out.println("json对象中的alice对象:"+msg.getJSONObject("alice"));
// System.out.println("json对象中的tom对象:"+msg.getJSONObject("tom"));
// System.out.println("json对象中的cndy对象的doctor_id属性:"+msg.getJSONObject("cndy").get("doctor_id"));
// System.out.println();
//返回json对象
return msg;
}
public static void JDBCc(){
String url = "jdbc:mysql://172.16.1.72:3306/my_hospital";
String user = "root";
String pwd = "haoyi123";
Connection con = null;
PreparedStatement pst = null;
String sql = "update doctor_info set doctor_pwd =? where doctor_id