JDBC方式访问数据库:

来源：互联网发布：加工中心仿真软件编辑：程序博客网时间：2024/06/05 08:13

Connectionstatement resultSet

package com.suanfa;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement ;public class MySqlTest {public static void main(String[] args) {       // TODO Auto-generated method stub       //准备访问数据的资源       String driver="com.mysql.jdbc.Driver";       String url="jdbc:mysql://localhost:3306/student";       String user="root";       String pwd="admin";        String sql="select * from stu";             //1，装载驱动            try {           Class.forName(driver);           //2.获得连接           Connection cn = DriverManager.getConnection(url,user,pwd);           //3.声明          Statement st = cn.createStatement();           //4.执行声明，并提交SQL语句           ResultSet rs=st.executeQuery(sql);           //5.处理结果集                     while(rs.next()){              int id = rs.getInt("id");              String name = rs.getString("name");              System.out.println(rs.getInt("id")+"  "                     +rs.getString("name"));                     //+"   "+                    //rs.getString("password"));           }           //6.关闭资源           rs.close();           st.close();           cn.close();                       } catch (ClassNotFoundException e) {                    e.printStackTrace();       }catch(SQLException se){           se.printStackTrace();       }      }}

阅读全文

0 0