JDBC数据查询

来源：互联网发布：网络尖兵和星空极速编辑：程序博客网时间：2024/06/10 15:45
import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import com.mysql.jdbc.Statement;public class JDBCtest {public static void main(String[] args) {String sql = "select * from tbl_user";//查询语句SQLConnection conn=null;   //定义一个连接Statement statement = null;   //定义一个语句ResultSet rs=null;     //定义一个结果集try {Class.forName("com.mysql.jdbc.Driver");  //定义一个连接数据库驱动conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/jsp_db", "root", "");//将链接赋值一个连接mysql的驱动链接statement =(Statement) conn.createStatement();  //将SQL语句赋值为一个mysql的执行语句rs=statement .executeQuery(sql);   //执行并获得结果集while(rs.next()){   //一开始指针指向第一个的前一个，每次执行一次之后向后移动一个单位System.out.print(rs.getInt("id")+" ");System.out.print(rs.getString("name")+" ");System.out.print(rs.getString("password")+" ");System.out.print(rs.getString("email")+" ");System.out.println();}} catch (Exception e) {// TODO: handle exceptione.printStackTrace();}finally {try {rs.close();   //从小到大进行关闭} catch (Exception e2) {// TODO: handle exception}try {statement.close();} catch (Exception e2) {// TODO: handle exception}try {conn.close();} catch (Exception e2) {// TODO: handle exception}}}}
0 0