java jdbc包_java包学习之JDBC

public class DemoJDBC {

public static void main(String[] args) throws ClassNotFoundException, SQLException {

Class.forName("com.mysql.jdbc.Driver");

// 通过DriverManager获取数据库连接

String url = "jdbc:mysql://ip地址:3306/shiro?useUnicode=true&characterEncoding=utf-8";

String user = "账号";

String password = "密码";

Connection connection = (Connection) DriverManager.getConnection(url, user, password);

PreparedStatement statement = (PreparedStatement) connection.prepareStatement(

"insert role ( roleDesc) value ( ?)");

statement.setString(1, "测试");

statement.executeUpdate();

ResultSet resultSet = statement.executeQuery("select * from user");

// 操作ResultSet结果集

while (resultSet.next()) {

// 第一种获取字段方式

System.out.println(resultSet.getString(1) + " " +

resultSet.getString(2) );

}

// 关闭数据库连接

resultSet.close();

statement.close();

connection.close();

}

}