jdbc实例

jdbc实例

地址：http://360193550.iteye.com/blog/1759845

• 博客分类：

• jsbc

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

Java代码

1. static Connection conn = null;
2. public static Connection getConnection() {
3. try {
4. Class.forName("com.mysql.jdbc.Driver");
5. conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/upload", "root", "123456");
6. return conn;
7. } catch (Exception e) {
8. e.printStackTrace();
9. return null;
10. }
11. }

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;  
          } 
    }

查询样例：

Java代码

1. public List<Tests> getAll()throws Exception
2. {
3. List<Tests> list = new ArrayList<Tests>();
4. Connection connection = getConnection();
5. Statement statament = connection.createStatement();
6. ResultSet rs = statament.executeQuery( "select * from tests" );
7. while(rs.next()){
8. String ids = rs.getString("id");
9. int id = Integer.parseInt(ids);
10. String names = rs.getString("names");
11. String sex = rs.getString("sex");
12. String email = rs.getString("email");
13. String blog = rs.getString("blog");
14. Tests tests = new Tests(id, names, sex, email, blog);
15. list.add(tests);
16. }
17. return list;
18. }

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;
    }

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

• jdbc连接数据库实例.7z (636.1 KB)
• 下载次数: 0