Java 手写数据库链接+映射model
‘’’
Class.forName(“com.microsoft.sqlserver.jdbc.SQLServerDriver”);
String url = "jdbc:sqlserver://xx.xx.xx.xx:xxxx;database=xxxx";
Connection conn = DriverManager.getConnection(url,"sa","xxxxx");
System.out.println(conn.toString());
System.out.println(conn.isValid(1000));
Statement st = conn.createStatement();
String sql = "SELECT * from userInfo where userPhone = 15377504766";
ResultSet rs = st.executeQuery(sql);
Class bean = Class.forName("com.jieyu.Userinfo");
Field fields[] = bean.getDeclaredFields();
for (Field field : fields) {
field.setAccessible(true);
}
//System.out.println(JSON.toJSONString(fields));
int i = 0;
while(rs.next()) {
Object obj = bean.newInstance();
Userinfo userinfo = (Userinfo)obj;
for (Field field : fields) {
String fieldName = field.getName();
String fieldType = field.getGenericType().toString();
switch(fieldType) {
case "class java.lang.Integer":
Integer intVal = rs.getInt(fieldName);
System.out.println(fieldName+" = "+intVal);
field.set(userinfo,intVal);
break;
case "class java.lang.String":
String str = rs.getString(fieldName);
System.out.println(fieldName+" = "+str);
field.set(userinfo,str);
break;
}
}
System.out.println(userinfo.toString());
‘’’