jdbc链接到数据库的示例代码

package cn.itcast.demo;


import java.sql.DriverManager;
import java.sql.*;






public class Demo1{

public static void main(String[] args) throws SQLException {
String url="jdbc:mysql://localhost:3309/day14";//url地址的写法
String username="root";//数据库用户名
String password="root";//数据库密码
DriverManager.registerDriver(new com.mysql.jdbc.Driver());//加载驱动
Connection conn=(Connection) DriverManager.getConnection(url, username, password);//获取链接
Statement  st=conn.createStatement();//获取向数据库发送请求的Statement对象
ResultSet rs=st.executeQuery("select * from users");//向数据库发送sql语句
while(rs.next()){
System.out.println(rs.getObject("id"));
System.out.println(rs.getObject("name"));
System.out.println(rs.getObject("password"));
System.out.println(rs.getObject("email"));
System.out.println(rs.getObject("birthday"));



}
rs.close();//释放资源，注意顺序
st.close();
conn.close();
}

}