一. JDBC访问数据库步骤:
1、注册数据库驱动
String driver = "com.mysql.jdbc.Driver";
Class.forName(driver);
2、获取数据库连接
String url = "jdbc:mysql://localhost:3306/xxx";
Connection cn = DriverManager.getConnection(url,"root","");
3、获取传输器对象
Statement stat = cn.createStatement();
4、执行SQL语句
String sql = "select * from dept";
ResultSet rs = stat.executeQuery(sql);
5、处理运行结果
int cols = rs.getMetaData().getColumnCount();
while(rs.next()){
for(int i =1 ; i <= cols ; i++){
//re.getString(i); //获取第几列的值,返回字符串类型
System.out.print(rs.getString(i) + "\t");
}
System.out.println(); //每一条数据打印完成加换行
}