jdbc

创建时间：2015/8/22 0:24
更新时间：2015/8/22 0:24

package com.text.mysql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;


public class Mysql1 {
     public static void main(String[] args) {

          Connection conn= null;
          Statement stmt=null;
          ResultSet rs = null;
          List<User> userList=new ArrayList<User>();
          try {
               Class.forName("com.mysql.jdbc.Driver");//加载驱动
          } catch (ClassNotFoundException e) {
               System.out.println("未找到驱动");
               e.printStackTrace();
              
          }
          try {
               conn= DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/sh","root","" );//获取数据库的链接
               stmt=conn.createStatement();//创建Statement对象
               rs = stmt.executeQuery("select * from t_user ");//执行SQL语句
               while(rs.next()) {
                    User u=new User();
                    u.setId(rs.getInt("id"));
                    u.setUserName(rs.getString("userName"));
                    u.setEmail(rs.getString("email"));
                    u.setCreateTime(rs.getDate("createTime"));
                    u.setUpdateTime(rs.getDate("updateTime"));
                    u.setUserPassowrd(rs.getString("userPassowrd"));
                    u.setType(rs.getInt("type"));
                    u.setStatus(rs.getInt("status"));
                    u.setTimeZone(rs.getString("timeZone"));
                    u.setLanguage(rs.getInt("language"));
                    userList.add(u);
               }
          } catch (SQLException e) {
               System.out.println("数据库连接失败");
               e.printStackTrace();
          }finally{
               try {
                    if(rs!=null){
                         rs.close();
                         rs=null;    
                    }
                    if(stmt!=null){
                         stmt.close();
                         stmt=null;
                    }
                    if(conn!=null){
                         conn.close();
                         conn=null;
                    }
               }catch(SQLException e){
                    e.printStackTrace();
                   
               }              
          }         
          for(User user: userList){
               System.out.println(user);
          }
     }
    

}