复制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. |
喜欢
讨厌