简单的jdbc工程代码

package cn.qt.jdbc;

import com.mysql.jdbc.Driver;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class jdbc01 {
    public static void main  (String[] args) {
        //1.注册驱动
        try {
           // Driver dic = new Driver();
            DriverManager.registerDriver(new com.mysql.jdbc.Driver());
            //2.获取连接
            Connection  conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/spring","root","123456");
            //3.获取操作数据库的具体数据库
            PreparedStatement pstm=conn.prepareStatement("select  * from account");
            //4.执行sql，得到结果集
            ResultSet rs=pstm.executeQuery();
            //5.打印
            while (rs.next()){

                System.out.println(rs.getString("name"));
            }
            rs.close();
            pstm.close();
            conn.close();
        }
        catch (Exception e)
        {
             System.out.println(e);
        }

    }
}

Comments