public class TestJdbc {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
String url = "jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8";
String username = "root";
String password = "1340508016";
//1.加载驱动
Class.forName("com.mysql.jdbc.Driver");
//2.创建一个数据库对象,代表数据库
Connection connection = DriverManager.getConnection(url, username, password);
//3.向数据库发送SQL的对象Statement
Statement statement = connection.createStatement();
//4.编写SQL语句
String sql = "select * from users";
//5.执行SQL语句,返回一个ResultSet结果集
ResultSet rs = statement.executeQuery(sql);
//6.遍历
while (rs.next()){
System.out.println("id"+rs.getObject("id"));
System.out.println("name"+rs.getObject("name"));
System.out.println("password"+rs.getObject("password"));
System.out.println("email"+rs.getObject("email"));
System.out.println("birthday"+rs.getObject("birthday"));
}
//7.关闭连接,释放资源
connection.close();
statement.close();
rs.close();
}
}
PreparedStatement:
public class TestJdbc02 {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
String url = "jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8";
String username = "root";
String password = "1340508016";
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection(url, username, password);
String sql = "insert into users(id, name, password, email, birthday) VALUES (?,?,?,?,?)";
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setInt(1,4);
preparedStatement.setString(2,"老六");
preparedStatement.setString(3,"123456");
preparedStatement.setString(4,"ll@qq.com");
preparedStatement.setDate(5,new Date(new java.util.Date().getTime()));
//受影响的行数
int i = preparedStatement.executeUpdate();
if (i>0){
System.out.println("插入成功");
}
preparedStatement.close();
connection.close();
}
}