jdbc实例

有的时候用到就忘了，特此记下！
（mysql数据库）获得jdbc连接：

static Connection conn = null;
    public static Connection getConnection() {  
        try {   
            Class.forName("com.mysql.jdbc.Driver");   
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/upload", "root", "123456");   
            return conn;  
         } catch (Exception e) {   
             e.printStackTrace();   
             return null;  
          } 
    }

查询样例：

public List<Tests> getAll()throws Exception
    {
        List<Tests> list = new ArrayList<Tests>();
        Connection connection = getConnection();
        Statement statament = connection.createStatement(); 
        ResultSet rs = statament.executeQuery( "select * from tests" );
        while(rs.next()){ 
            String ids = rs.getString("id");
            int id = Integer.parseInt(ids);
            String names = rs.getString("names");
            String sex = rs.getString("sex");
            String email = rs.getString("email");
            String blog = rs.getString("blog");
            Tests tests = new Tests(id, names, sex, email, blog);
            list.add(tests);
        }    
        return list;
    }

随便参考：[url]http://leeldy.blog.163.com/blog/static/139853062009710115938902/[/url]