*#mysql语句练习!
使用JDBC时,我们都会很自然得使用下列语句:
java 代码
Class.forName(“com.mysql.jdbc.Driver”);
String url = “jdbc:mysql://127.0.0.1/test?useUnicode=true&characterEncoding=utf-8”;
String user = " ";
String psw = " ";
Connection con = DriverManager.getConnection(url,user,psw);
上述代码做用是:在调用DriverManager的getConnection方法之前,保证相应的Driver类已经被加载到 jvm中,并且完成了类的初始化工作。
创建Statement
Statement用于在已经建立数据库连接的基础上,向数据库发送要执行的SQL语句。Statement对象只能执行不带参数的简单SQL语句。
通过调用 Connection 对象的 createStatement 方法创建该对象,该对象用于执行静态的 SQL 语句,并且返回执行结果。
Java代码:Statement statement = connection.createStatement();
通过Statement执行SQL语句:
Statement statement = connection.createStatement();
String sql = “SELECT username FROM gg”;
String sql2 = “insert into gg(username) values(‘456’)”;
String sql3 = “delete from gg where username=‘456’”;
源代码:
import java.sql.*;
public class ASS{
//获取数据库连接的方法
public static void main(String[] args) throws ClassNotFoundException, SQLException {
// 将驱动程序加载到内存
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/dd";
String username = "root";
String password = "15031260181chen";
//获取连接
Connection connection = DriverManager.getConnection(url,username,password);
Statement statement = connection.createStatement();
String sql = "SELECT username FROM gg";
String sql2 = "insert into gg(username) values('456')";
//String sql3 = "delete from gg where username='456'"; //删除用户名为456
statement.executeUpdate(sql2); //executeUpdate 的返回值是一个整数(int)
// statement.executeUpdate(sql3);
ResultSet resultSet = statement.executeQuery(sql); //查询返回的结果集
while(resultSet.next()){
System.out.println("用户名:"+resultSet.getString( "username"));
}
resultSet.close();
statement.close();
connection.close();
}
}
此时表中显示为
源代码:
import java.sql.*;
public class ASS{
//获取数据库连接的方法
public static void main(String[] args) throws ClassNotFoundException, SQLException {
// 将驱动程序加载到内存
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/dd";
String username = "root";
String password = "15031260181chen";
//获取连接
Connection connection = DriverManager.getConnection(url,username,password);
Statement statement = connection.createStatement();
String sql = "SELECT username FROM gg";
String sql2 = "insert into gg(username) values('456')";
String sql3 = "delete from gg where username='456'";
statement.executeUpdate(sql2);
statement.executeUpdate(sql3); //删除表中数据
ResultSet resultSet = statement.executeQuery(sql);
while(resultSet.next()){
System.out.println("用户名:"+resultSet.getString( "username"));
}
resultSet.close(); //关闭方法
statement.close();
connection.close();
}
}
表为: