bat文件调用java入门实例.docVIP

bat文件调用java入门实例 本例主要是讲解 简单的bat调用java执行数据库的查询和插入值 1，新建项目如下图 2，编写DBConnection.java代码 package oracle; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class DBConnection { /** * 方法?? * 详述: 链接 * 开发人员：ldh * 创建时间??012-6-11 * @param args */ private static String url=jdbc:oracle:thin:@localhost:1521:orcl; private static String user=scott; private static String password=; private static Connection connection=null; public static Connection getConnection(){ try { Class.forName(oracle.jdbc.OracleDriver); connection=DriverManager.getConnection(url, user, password); } catch (SQLException e) { e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); } return connection; } } 3，编写TestJdbcs.java的代码 package oracle; import java.sql.CallableStatement; import java.sql.Connection; import java.sql.SQLException; import java.sql.Types; public class TestJdbcs { /** * 方法?? * 详述: * 开发人员：梁丹华 * 创建时间??012-6-11 * @param args */ public static void main(String[] args) { TestJdbcs tb=new TestJdbcs(); System.out.println(查询结果如下+); tb.selectJdbc(); System.out.println(插入值如下:); tb.insertJdbc(); } public void selectJdbc(){ Connection conn = DBConnection.getConnection(); String sql={call scott.check_user(?,?)}; try { CallableStatement cst = conn.prepareCall(sql); //cst.setString(1, hua); cst.setString(1, 41); cst.registerOutParameter(2, Types.VARCHAR); cst.execute(); String tst = cst.getString(2); System.out.println(tst); } catch (SQLException e) { e.printStackTrace(); } } public void insertJdbc(){ Connection conn = DBConnection.getConnection(); String sql={call INSERT_TABLE1(?,?)}; try { CallableStatement cst = conn.prepareCall(sql); //cst.setString(1, hua); cst.setString(1, zsts); cst.setString(2, 通级7); cst.execute(); System.out.println(通级6); } catch (SQLException e) { e.printStackTrace(