详细编写：Java面向控台的小案例

案例"/>

详细编写：Java面向控台的小案例

一、方式一：不进行封装

public class T_userTest {public static void main(String[] args) {try {Class.forName("com.mysql.jdbc.Driver");DriverManager.registerDriver(new Driver());Connection connection = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/jdbc1", "root", "123456");String sql1="select * from t_user;";String sql2="insert into t_user(account,PASSWORD,nickname) values(?,?,?)";String  sql3="delete from t_user where id=?;";String sql4="update t_user set nickname=? where id=?;";PreparedStatement preparedStatement = connection.prepareStatement(sql1);PreparedStatement preparedStatement2 = connection.prepareStatement(sql2);PreparedStatement preparedStatement3 = connection.prepareStatement(sql3);PreparedStatement preparedStatement4 = connection.prepareStatement(sql4);//实现查询数据库中数据功能ResultSet resultSet = preparedStatement.executeQuery();while(resultSet.next()){System.out.println(resultSet.getInt("id")+"---"+resultSet.getString("account")+"---"+resultSet.getString("PASSWORD")+"---"+resultSet.getString("nickname"));}//实现控制台插入数据到数据库的功能Scanner scanner = new Scanner(System.in);System.out.println("请输入插入的信息：");String account = scanner.nextLine();String password = scanner.nextLine();String nickname = scanner.nextLine();preparedStatement2.setObject(1,account);preparedStatement2.setObject(2,password);preparedStatement2.setObject(3,nickname);int i = preparedStatement2.executeUpdate();if(i>0){System.out.println("插入成功");}else{System.out.println("插入失败");}//实现控制台删除数据库中数据的功能System.out.println("请输入删除的id号：");int id = scanner.nextInt();preparedStatement3.setObject(1,id);int i1 = preparedStatement3.executeUpdate();if(i1>0){System.out.println("删除成功");}else{System.out.println("删除失败");}//实现控制台修改数据库中数据的功能System.out.println("请输入修改的nickname：");String newnickname = scanner.nextLine();System.out.println("请输入修改的信息id：");int id1 = scanner.nextInt();preparedStatement4.setObject(1,newnickname);preparedStatement4.setObject(2,id1);int i2 = preparedStatement4.executeUpdate();if(i2>0){System.out.println("修改成功");}else{System.out.println("修改失败");}System.out.println("最终数据库的数据为：");while(resultSet.next()){System.out.println(resultSet.getInt("id")+"---"+resultSet.getString("account")+"---"+resultSet.getString("PASSWORD")+"---"+resultSet.getString("nickname"));}} catch (Exception e) {e.printStackTrace();}}
}

二、方式二：封装连接工具类、封装增、删、查、改等方法进行调用

1. 配置信息文件jdbc.properties

#该文件是一个配置文件
#我们可以在该文件里面完成一些配置信息在通过Java程序
#key=valued的形式配置信息
# 配置数据库连接信息driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/jdbc1
name=root
password=123456

2. 连接工具类

public class JDBC_Utiles_1 {private static String user;private static String url;private static String password;static {InputStream stream=null;Properties properties=null;try {stream = JDBC_Utiles_1.class.getClassLoader().getResourceAsStream("jdbc.properties");properties = new Properties();properties.load(stream);user = properties.getProperty("user");password = properties.getProperty("password");url = properties.getProperty("url");} catch (Exception e) {e.printStackTrace();}finally {try {stream.close();} catch (IOException e) {e.printStackTrace();}}}public static Connection getConnection(){Connection connection=null;try {connection= DriverManager.getConnection(url, user, password);} catch (SQLException e) {e.printStackTrace();}return connection;}public static void closeAll(Connection connection, PreparedStatement preparedStatement, ResultSet resultSet){try {if(connection !=null){connection.close();}} catch (SQLException e) {e.printStackTrace();}try {if(preparedStatement!=null){preparedStatement.close();}} catch (SQLException e) {e.printStackTrace();}try {if(resultSet!=null){resultSet.close();}} catch (SQLException e) {e.printStackTrace();}}public static void closAll(Connection connection, PreparedStatement preparedStatement){try {if(connection !=null){connection.close();}} catch (SQLException e) {e.printStackTrace();}try {if(preparedStatement!=null){preparedStatement.close();}} catch (SQLException e) {e.printStackTrace();}}
}

3. 增、删、查、改功能的方法

public class Mothed {//插入数据public void testInster()  {Connection connection = getConnection();PreparedStatement preparedStatement = null;try {String sql="insert into t_user(account,PASSWORD,nickname) values(?,?,?)";preparedStatement = connection.prepareStatement(sql);Scanner scanner = new Scanner(System.in);System.out.println("请输入插入的信息：");String account = scanner.nextLine();String password = scanner.nextLine();String nickname = scanner.nextLine();preparedStatement.setObject(1,account);preparedStatement.setObject(2,password);preparedStatement.setObject(3,nickname);int i = preparedStatement.executeUpdate();if(i>0){System.out.println("插入成功");}else{System.out.println("插入失败");}} catch (SQLException e) {e.printStackTrace();}}//修改数据public void testUpdate()  {Connection connection = getConnection();PreparedStatement preparedStatement = null;try {String sql="update t_user set nickname=? where id=?;";Scanner scanner = new Scanner(System.in);System.out.println("请输入修改的nickname：");String newnickname = scanner.nextLine();System.out.println("请输入修改的信息id：");preparedStatement = connection.prepareStatement(sql);int id1 = scanner.nextInt();preparedStatement.setObject(1,newnickname);preparedStatement.setObject(2,id1);int i2 = preparedStatement.executeUpdate();if(i2>0){System.out.println("修改成功");}else{System.out.println("修改失败");}} catch (SQLException e) {e.printStackTrace();}finally {//关闭资源closAll(connection,preparedStatement);}}//删除数据public void testDelte() {Connection connection = getConnection();PreparedStatement preparedStatement = null;try {String  sql="delete from t_user where id=?;";preparedStatement = connection.prepareStatement(sql);System.out.println("请输入删除的id号：");Scanner scanner = new Scanner(System.in);int id = scanner.nextInt();preparedStatement.setObject(1,id);int i1 = preparedStatement.executeUpdate();if(i1>0){System.out.println("删除成功");}else{System.out.println("删除失败");}} catch (Exception e) {e.printStackTrace();}finally {//关闭资源closAll(connection,preparedStatement);}}//查看数据public void testSelect()  {Connection connection = getConnection();PreparedStatement preparedStatement = null;ResultSet resultSet=null;try {String sql="select * from t_user;";preparedStatement = connection.prepareStatement(sql);resultSet = preparedStatement.executeQuery();while(resultSet.next()){System.out.println(resultSet.getInt("id")+"---"+resultSet.getString("account")+"---"+resultSet.getString("PASSWORD")+"---"+resultSet.getString("nickname"));}} catch (Exception e) {e.printStackTrace();}finally {//关闭资源closeAll(connection,preparedStatement,resultSet);}}
}

4. 调用方法

public class Test {public static void main(String[] args) {Mothed mothed = new Mothed();//调用查询方法mothed.testSelect();//调用插入方法mothed.testInster();//调用修改方法mothed.testUpdate();//调用删除方法mothed.testDelte();}
}