jdbc 1 打通数据库连接

DB类：

public class DBUtil {

//url

private static final String URL="jdbc:mysql://localhost:3306/mytest";

//用户名

private static final String Name="root";
//密码

private static final String Password="root123";

//定义一个conn存连接

private static Connection conn =null;
static{

try{

//加载驱动

Class.forName("com.mysql.jdbc.Driver");
//获得数据库连接
conn = DriverManager.getConnection(URL,Name,Password);
}catch(Exception e){
e.printStackTrace();
}

}

//对外提供一个公共的方法返回连接

public static Connection getConn() {
return conn;
}
/*public static void main(String []args){
try {
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//获得数据库丽娜姐

java.sql.Connection conn = DriverManager.getConnection(URL,Name,Password);
//
Statement st = conn.createStatement();

String sql ="select * from huhu limit 10"; 

ResultSet rs = st.executeQuery(sql);

while(rs.next()){
System.out.println(rs.getString("Sage"));
}
conn.close();

} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}*/


}