一个简单的例子,用的MySql数据库,用其它数据库就是驱动和URL那些配置变一下,另外,导入的JAR包也要换一下。
package test.hello;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class HelloJDBC {
/**
* @param args
*/
public static void main(String[] args) {
String driver = "com.mysql.jdbc.Driver";//驱动
String url = "jdbc:mysql://localhost:3306/test";//数据库URL
String userName = "root";//数据库用户名
String pas = "root";//密码
// 加载驱动
try {
Class.forName(driver);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// 得到连接
Connection conn;
try {
conn = DriverManager.getConnection(url, userName, pas);//得到连接
String sql = "select * from student";//编写查询的SQL语句
PreparedStatement pstmt = conn.prepareStatement(sql);//创建PreparedStatement
ResultSet rs = pstmt.executeQuery();//执行查询得到结果集
while (rs.next()) {//遍历结果集
String uid = rs.getString("uid");
String uname = rs.getString("uname");
String uage = rs.getString("uage");
System.out.println("-------------------------");
System.out.println("ID:" + uid);
System.out.println("Name:" + uname);
System.out.println("uage:" + uage);
System.out.println("-------------------------");
}
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
}