JDBC处理DML(SXT)
来源:互联网 发布:vb控制鼠标点击 源码 编辑:程序博客网 时间:2024/06/05 15:35
JDBC处理DML(SXT)
Demo1
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import com.sun.org.apache.xalan.internal.xsltc.runtime.Parameter;
- public class TestDML
- {
- /**
- * @JDBC处理DML。接收手动输入的参数
- */
- public static void main(String[] args)
- {
- // TODO Auto-generated method stub
- if (args.length != 4)
- {
- System.out.println("Error,plesase input again!");
- System.exit(-1);
- }
- int userid = 0;
- try
- {
- userid = Integer.parseInt(args[0]);
- } catch (NumberFormatException e)
- {
- System.out.println("Number error");
- System.exit(-1);
- }
- String usernameString = args[1];
- String passwordString = args[2];
- String userflaString = args[3];
- Connection conn = null;
- Statement stmt = null;
- ResultSet rs = null;
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- String url = "jdbc:mysql://localhost:3306/college";
- String user = "root";
- String password = "123456";
- conn = DriverManager.getConnection(url, user, password);
- stmt = conn.createStatement();
- String sql = "insert into user (userId,userName,userPassword,userFlag)values(" + userid+",'"+usernameString+"','"+passwordString+"','" +userflaString+ "')";
- stmt.executeUpdate(sql);
- System.out.println(sql);
- rs = stmt.executeQuery("select * from user where userName='testDML4'");
- while (rs.next())
- {
- System.out.print("username:");
- System.out.println(rs.getString("userName"));
- System.out.print("password:");
- System.out.println(rs.getString("userPassword"));
- }
- } catch (ClassNotFoundException e)
- {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (SQLException e)
- {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } finally
- {
- try
- {
- if (rs != null)
- {
- rs.close();
- rs = null;
- }
- if (stmt != null)
- {
- stmt.close();
- stmt.close();
- }
- if (conn != null)
- {
- conn.close();
- conn = null;
- }
- } catch (SQLException e)
- {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- }
- }
Demo2
- import java.sql.*;
- /**
- * JDBC处理DML2。无输入参数。
- */
- public class TestJDBCDML
- {
- /**
- * @param args
- */
- public static void main(String[] args)
- {
- Connection conn = null;
- Statement stmt = null;
- ResultSet rs = null;
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- String url = "jdbc:mysql://localhost:3306/college";
- String user = "root";
- String password = "123456";
- conn = DriverManager.getConnection(url, user, password);
- stmt = conn.createStatement();
- String sql = "insert into user (userName,userPassword,userFlag)values('testDML2','123','dml')";
- stmt.executeUpdate(sql);
- rs = stmt.executeQuery("select * from user where userName='testDML2'");
- while(rs.next())
- {
- System.out.print("username:");
- System.out.println(rs.getString("userName"));
- System.out.print("password:");
- System.out.println(rs.getString("userPassword"));
- }
- } catch (ClassNotFoundException e)
- {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (SQLException e)
- {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } finally
- {
- try
- {
- if(rs != null)
- {
- rs.close();
- rs = null;
- }
- if(stmt != null)
- {
- stmt.close();
- stmt.close();
- }
- if (conn != null)
- {
- conn.close();
- conn = null;
- }
- } catch (SQLException e)
- {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- }
- }
- JDBC处理DML(SXT)
- JDBC中处理事务(SXT)
- JDBC:用Batch处理多个SQL(SXT)
- JDBC处理前后移动结果集(SXT)
- JDBC进阶(SXT)
- JDBC:灵活指定SQL中的变量(SXT)
- JDBC调用存储过程基本流程(SXT)
- 03.JDBC数据库编程之处理DML语句
- SXT:JDBC超级入门——JDBC编程步骤
- jdbc dml语句执行
- jdbc dml语句
- JDBC学习笔记之dml语句(PreparedStatement&Statement)
- JDBC的DML操作模板
- Oracle SQL语句处理过程详解(DML)
- Oracle处理数据(DML+DDL+DCL)+事务
- 用二分查找法对数组查找(SXT)
- SQL DDL & DML from Oracle JDBC toturial
- JDBC-实现操作:增、删、改(DML)
- 如何教育懒孩子
- symbian example
- 图像中运动检测、提取与滤波算法
- c++位操作
- 小於正整數n的任意個正整數相加其和等於n的做法
- JDBC处理DML(SXT)
- [职业生涯] 28句话让你的人际关系更上一层楼!
- 构建ARM Linux系统实践
- buffalo.js文件分析(一)
- JDBC:用Batch处理多个SQL(SXT)
- 如何培养女儿爱护东西的好习惯?
- 傲游今天出现问题
- Windows2000 在保存IP安全数据时出现拒绝访问错误80070005的解决方法
- 使用 Java 开源工具建立一个灵活的搜索引擎