浅析JDBC的ResultSet接口和使用MySQL语句查询数据

2025-11-05 11:24:16分类：应用开发阅读(42469)

复制import java.sql.Connection;  import java.sql.DriverManager;  import java.sql.ResultSet;  import java.sql.SQLException;  import java.sql.Statement;  public class Example27 {      publicstatic void main(String[] args) {          // TODO Auto-generated method stub          String driver="com.mysql.jdbc.Driver";          try {              //加载驱动              Class.forName(driver);              //数据库地址，浅析本机、站群服务器接口端口号3306、b2b信息网和使数据库名为test              String url="jdbc:mysql://localhost:3306/test";              //用户名              String user="root";              //密码              String pwd="168168";              //连接数据库              Connection conn=DriverManager.getConnection(url,用M语句user,pwd);              //创建Statement对象              Statement stmt=conn.createStatement();              String sql="select * from student where id=A02";              //执行SQL语句              ResultSet rs=stmt.executeQuery(sql);              //获取id为A02的网站模板数据              if(rs.next()){                  System.out.println("id="+rs.getString("id"));                  System.out.println("name="+rs.getString("name"));                  System.out.println("age="+rs.getInt("age"));              }          } catch (ClassNotFoundException e) {              // TODO Auto-generated catch block              e.printStackTrace();          } catch (SQLException e) {              // TODO Auto-generated catch block              e.printStackTrace();          }      }  }  1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.41.42.