JDBC连接数据库 必须引用架包 去网上下载一个MySQL连接数据库的架包(竟然不能添加附件)
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
//1. 注册驱动
//第一种方式
// Driver driver = new Driver() ;
// DriverManager.registerDriver(driver) ;
//第二种方式
//Driver d = (Driver)Class.forName("com.mysql.jdbc.Driver").newInstance() ;
//DriverManager.registerDriver(d) ;
//第三种方式 建议使用第三种
Class.forName("com.mysql.jdbc.Driver") ; //自动进行注册
//2. 创建一个连接对象
//第一种方式
//Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb?user=root&password=root") ;
//第二种方式
//读取properties文件
// Properties pro = new Properties() ;
// InputStream in = JdbcDemo3.class.getClassLoader().getResourceAsStream("dbcfg.properties") ;
// pro.load(in) ;
// Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb", pro) ;
//第三种方式
/* String driverClass = "" ;
String url = "" ;
String user = "" ;
String password = "" ;
Properties pro = new Properties() ;
InputStream in = JdbcDemo3.class.getClassLoader().getResourceAsStream("dbcfg.properties") ;
pro.load(in) ;
driverClass = pro.getProperty("driverClass") ;
url = pro.getProperty("url") ;
user = pro.getProperty("user") ;
password = pro.getProperty("password") ;
// Connection conn = DriverManager.getConnection(url,user,password) ;
*/
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","root","123456") ; //
//3. 创建一个sql语句的发送命令对象
Statement stmt = conn.createStatement() ;
//4. 执行SQL,拿到查询的结构集对象
ResultSet rs = stmt.executeQuery("select * from stu") ;
// ResultSet rs = stmt.executeQuery("select id 编号,name 姓名 from stu") ;
//String sql = "insert into stu(id,name,sex,age,address) values(12,'东方不败','男',20,'黒木崖')" ;
// String sql = "update stu set sex ='女' where id = 12" ;
// String sql = "delete from stu where id = 12" ;
// int n = stmt.executeUpdate(sql) ;
// System.out.println(n);
//5. 输出结果集的数据
while(rs.next()){
System.out.println(rs.getInt("id") + ":" + rs.getString("name") + ":" + rs.getString("address"));
}
/* while(rs.next()){
// System.out.println(rs.getInt("id") + ":" + rs.getString("name") + ":" + rs.getString("address"));
//第一种:根据字段名拿取 (推荐)
// int id = rs.getInt("编号") ; //是结果集的字段名
// String name = rs.getString("姓名") ;
//第二种: 根据字段的索引(索引从1开始)
int id = rs.getInt(1) ;
String name = rs.getString(2) ;
System.out.println(id + ":" + name);
}
*/
//6. 关闭连接,命令对象,结果集
rs.close() ;
stmt.close();
conn.close() ;
文章来源:http://blog.csdn.net/u014368040/article/details/51252875