json 数据传输实例

最新推荐文章于 2024-06-23 17:00:00 发布

c_1996

最新推荐文章于 2024-06-23 17:00:00 发布

阅读量2.2k

点赞数 1

学号姓名年龄性别住址
1010 janne 20 man shanghai
1011 tom 22 women zhongguo
1055 jerry 18 man haerbiin
2033 sb 15 man beijing
1555 perry 60 man jinguo
2366 dff 34 woman Ameria
1066 Paris 28 woman Beijing
转换后的Json格式字符串:
{student:{record:[{学号:1010,姓名:janne,年龄:20,性别:ma,住址:shanghai},{学号:1011,姓名:tom,年龄:22,性别:wo,住址:zhongguo},{学号:1055,姓名:jerry,年龄:18,性别:ma,住址:haerbiin},{学号:1066,姓名:Paris,年龄:28,性别:wo,住址:Beijing},{学号:1555,姓名:perry,年龄:60,性别:ma,住址:jinguo},{学号:2033,姓名:sb,年龄:15,性别:ma,住址:beijing},{学号:2366,姓名:dff,年龄:34,性别:wo,住址:Ameria}]}}

 
        package  
        com.json; 
       
        import  
        java.sql.*; 
       
        import  
        java.lang.reflect.*; 
       
        public  
        class  
        JsonConvert { 
       
        //设置数据库连接属性 
       
        Connection connection= 
        null 
        ; 
       
        String driverName = 
        "com.mysql.jdbc.Driver" 
        ; 
       
        String url =  
        "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=gb2312" 
        ; 
       
        String user =  
        "root" 
        ; 
       
        String password =  
        "000000" 
        ; 
       
        String table= 
        "student" 
        ; 
       
        int  
        count; 
       
        public  
        static  
        void  
        main(String[] args) { 
       
        // TODO Auto-generated method stub 
       
        JsonConvert jv= 
        new  
        JsonConvert(); 
       
        //jv.getResult(); 
       
        System.out.println(jv.TableToJson()); 
       
        } 
       
        public  
        String TableToJson(){ 
        //把表记录转换成Json格式 
       
        StringBuffer resultJson= 
        new  
        StringBuffer(); 
       
        resultJson.append( 
        "{" 
        + 
        this 
        .table+ 
        ":" 
        ); 
       
        resultJson.append( 
        "{record:[" 
        ); 
       
        ResultSet rs= 
        this 
        .getResult(); 
       
        try 
        { 
       
        int  
        i= 
        0 
        ; 
       
        while 
        (rs.next()){ 
       
        resultJson.append( 
        "{" 
        ); 
       
        for 
        ( 
        int  
        j= 
        0 
        ;j<rs.getMetaData().getColumnCount();j++){ 
       
        //System.out.println(rs.getMetaData().getColumnName(j+1)); 
       
        String cn=rs.getString(j+ 
        1 
        ); 
       
        resultJson.append(rs.getMetaData().getColumnName(j+ 
        1 
        )+ 
        ":" 
        +cn); 
       
        if 
        (j<rs.getMetaData().getColumnCount()- 
        1 
        ) 
       
        resultJson.append( 
        "," 
        ); 
       
        } 
       
        if 
        (i==(count- 
        1 
        )) 
       
        resultJson.append( 
        "}" 
        ); 
       
        else 
       
        resultJson.append( 
        "}," 
        ); 
       
        i++; 
       
        } 
       
        resultJson.append( 
        "]}}" 
        ); 
       
        connection.close(); 
       
        } 
        catch 
        (Exception se){ 
       
        se.printStackTrace(); 
       
        } 
       
        return   
        resultJson.toString(); 
       
        } 
       
        private  
        ResultSet getResult(){ 
        //获取表记录 
       
        ResultSet rs= 
        null 
        ; 
       
        try 
        { 
       
        Class.forName(driverName); 
       
        this 
        .connection = DriverManager.getConnection(url,user,password); 
       
        String statement= 
        "select * from student " 
        ; 
       
        PreparedStatement ps= 
        this 
        .connection.prepareStatement(statement); 
       
        rs=ps.executeQuery(); 
       
        ps= 
        this 
        .connection.prepareStatement( 
        "select count(*) as cc from student" 
        );  
       
        ResultSet rs1=ps.executeQuery(); 
       
        rs1.next(); 
       
        count=rs1.getInt( 
        "cc" 
        ); 
       
        } 
        catch 
        (ClassNotFoundException noclass){ 
       
        noclass.printStackTrace(); 
       
        } 
       
        catch 
        (SQLException se){ 
       
        se.printStackTrace(); 
       
        } 
       
        catch 
        (Exception e){ 
       
        e.printStackTrace(); 
       
        } 
       
        return  
        rs; 
       
        } 
       
        }