jdbc连接数据库

本文源自 http://www.hollischuang.com/archives/489

1.创建数据库属性

static final String url="jdbc:mysql://127.0.0.1/数据库名";

static final String driver="com.mysql.jdbc.Driver";

static final String user="数据库账号";

statci final String password="数据库密码";

public Connection conn=null;//连接

public PreparedStatement pst=null;//处理器

//再构造器中创建连接

public JDBCUtil(String sql){
try {
Class.forName(driver);
conn=DriverManager.getConnection(url,user,password);
pst=conn.prepareStatement(sql);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}
//关闭连接的方法
public void close(){
try {
this.conn.close();
this.pst.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

demo应用的

package com.demo.bean;


import java.sql.ResultSet;


import com.demo.util.JDBCUtil;


public class User {


static String sql=null;

static JDBCUtil dbl=null;

static ResultSet ret=null;

public static void main(String[] args) {
sql="select * from student";

dbl=new JDBCUtil(sql);

try{
ret=dbl.pst.executeQuery();
while (ret.next()) {  
            String uid = ret.getString(1);  
            String ufname = ret.getString(2);  
            String ulname = ret.getString(3);  
            String udate = ret.getString(4);  
            System.out.println(uid + "\t" + ufname + "\t" + ulname + "\t" + udate );  
        }
ret.close();  
dbl.close();//关闭连接  
}catch(Exception e){
e.printStackTrace();
}
}
}