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();
}
}
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();
}
}