Connectioncon=null;//创建用于连接数据库的Connection对象try{Class.forName("com.mysql.jdbc.Driver");//加载Mysql数据驱动System.out.println("conectando1");con=DriverManager.g...
Connection con = null; //创建用于连接数据库的Connection对象 try { Class.forName("com.mysql.jdbc.Driver");// 加载Mysql数据驱动 System.out.println("conectando1"); con = DriverManager.getConnection( "jdbc:mysql://localhost:3306/programbase", "root", "123456");// 创建数据连接 System.out.println("conectando2"); Statement stmt = conn.createStatement(); // 创建用于执行静态sql语句的Statement对象 int result = stmt.executeUpdate("insert into resiger (name,sex,code) value('sl','nan','123')"); con.close(); //关闭数据库连接 } catch (Exception e) { System.out.println("注册失败" + e.getMessage()); }
我做了一个函数:public void insert(String sql) {
Connectioncon=null;try{Class.forName("com.mysql.jdbc.Driver");System.out.println("conectando1");con=DriverManager.getConnection("jdbc:mysql://localhost:3306/programbase", "root","123456");System.out.println("conectando2");Statement st = con.createStatement(); result = st.executeUpdate("insert into resiger (name,sex,code) value('sl','nan','123')");con.close(); } catch (Exception e) {System.out.println("注册失败" + e.getMessage());e.printStackTrace();}}
展开