public static void main(String[] args) throws SQLException, ClassNotFoundException, JSONException { PostgresDb db = new PostgresDb(); // db.setUrl("jdbc:postgresql://localhost:5432/powaaim"); try { Class.forName("org.postgresql.Driver"); c = DriverManager.getConnection(db.getUrl(), db.getUser(), db.getPass()); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } st = c.createStatement(); rs = st.executeQuery("SELECT id, name, externalshopid from shop where name='David_3'"); System.out.println("id" + " " + "name" + " " + "externalshopid"); c.close(); obj = new JSONObject(); while (rs.next()) { int id = rs.getInt("id"); String externaId = rs.getString("externalshopid"); String name = rs.getString("name"); // System.out.println(id+ " " + " "+ name + " " +" "+ externaId); System.out.println(); obj.put("id", id); obj.put("name", name); obj.put("externalshopid", externaId); System.out.print(obj); } }
public Connection createConnection() throws Exception { Connection con; try { Class.forName(dbClass); con = DriverManager.getConnection(dbUrl, dbUser, dbPassword); } catch (Exception e) { e.printStackTrace(); throw e; } return con; }
/** * Establece una conexión con la base de datos, usando el usuario y clave especificados. Si ya hay * una conexi�n, esta es cerrada. * * @param usuario Una cadena con el nombre de usuario * @param clave Una cadena con la clave * @return Regresa verdadero (true) si pudo establecer la conexión de lo contrario regresa falso * (false). */ protected boolean conectar(String usuario, String clave) throws Exception { // Registra el controlador de manera implicita Class.forName(controlador).newInstance(); // Obtiene la conexión System.err.println(url + "," + usuario + "," + clave + ":OK!!!"); this.conexión = DriverManager.getConnection(url, usuario, clave); // Actualiza usuario y clave del middler this.usuario = usuario; this.clave = clave; return this.conexión != null; } // Fin conectar
public static Connection getConnect() { try { /*if (!getConnect) { if (!con.isValid(1)) {*/ String host = "jdbc:mysql://localhost:3306/2761DB"; String uname = "root"; String upassword = "******"; con = DriverManager.getConnection(host, uname, upassword); getConnect = true; /*} }*/ } catch (SQLException err) { System.out.println(err.getMessage()); } return con; }
public CachedRowSet query(String sql, int pageSize, int page) throws Exception { // 加载驱动 Class.forName(driver); try ( // 获取数据库连接 Connection conn = DriverManager.getConnection(url, user, pass); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(sql)) { // 使用RowSetProvider创建RowSetFactory RowSetFactory factory = RowSetProvider.newFactory(); // 创建默认的CachedRowSet实例 CachedRowSet cachedRs = factory.createCachedRowSet(); // 设置每页显示pageSize条记录 cachedRs.setPageSize(pageSize); // 使用ResultSet装填RowSet,设置从第几条记录开始 cachedRs.populate(rs, (page - 1) * pageSize + 1); return cachedRs; } }
public static void main(String[] args) { Connection con = null; Statement stat = null; String s; try { Class.forName("oracle.jdbc.driver.OracleDriver"); // con=DriverManager.getConnection("jdbc:oracle:oci8:@oracle9i","scott","tiger"); // // con=DriverManager.getConnection("jdbc:oracle:thin:@saraswati:1521:oracle10g","scott","tiger"); con = DriverManager.getConnection("jdbc:oracle:thin:@//localhost:1521/XE", "scott", "tiger"); /*Properties p=new Properties(); p.put("user","scott"); p.put("password","tiger");*/ // Driver d=(Driver)Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance(); // Connection con=d.connect("jdbc:odbc:oradsn",p); // Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); // con=DriverManager.getConnection("jdbc:odbc:namadsn","scott","tiger"); System.out.println("The connection is successful."); } catch (Exception e) { e.printStackTrace(); } try { stat = con.createStatement(); s = "create table student(Rollno int,Name varchar2(50),serName varchar2(50))"; stat.executeUpdate(s); } catch (SQLException e) { e.printStackTrace(); } try { stat = con.createStatement(); s = "insert into student values(1,'Namrata','Marathe')"; stat.executeUpdate(s); s = "insert into student values(2,'Arjun','Marathe')"; stat.executeUpdate(s); s = "insert into student values(3,'Rahul','Marathe')"; stat.executeUpdate(s); } catch (SQLException e) { e.printStackTrace(); } try { stat.close(); } catch (SQLException e) { } System.out.println("create is successful:"); try { stat = con.createStatement(); s = "select * from student"; ResultSet rset = stat.executeQuery(s); while (rset.next()) System.out.println(rset.getInt(1) + " " + rset.getString(2) + " " + rset.getString(3)); } catch (SQLException e) { e.printStackTrace(); } try { stat.close(); } catch (SQLException se) { } }
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { server svr = new server(); response.setContentType("text/html"); HttpSession session = request.getSession(true); PrintWriter out = response.getWriter(); String email = request.getParameter("email"); String pw1 = request.getParameter("pw1"); String pw2 = request.getParameter("pw2"); String error = null; String username = session.getAttribute("username").toString(); if (pw1.compareTo(pw2) != 0) { error = "Passwords do not match"; session.setAttribute("ErrorMessage", error); response.sendRedirect("home.jsp"); } try { Statement st = null; String strQuery = null; if ((pw1.length() == 0) && (email.length() == 0)) { session.setAttribute("ErrorMessage", "Nothing to change!"); response.sendRedirect("home.jsp"); } else if ((pw1.length() != 0) && (email.length() != 0)) { strQuery = "UPDATE `twitter2012`.`users` SET `password`='" + pw1 + "', `email_address`='" + email + "' WHERE `username`='" + username + "'"; session.setAttribute("email", email); } else if ((pw1.length() == 0) && (email.length() != 0)) { strQuery = "UPDATE `twitter2012`.`users` SET `email_address`='" + email + "' WHERE `username`='" + username + "'"; session.setAttribute("email", email); } else if ((pw1.length() != 0) && (email.length() == 0)) { strQuery = "UPDATE `twitter2012`.`users` SET `password`='" + pw1 + "' WHERE `username`='" + username + "'"; } Connection dbcon = null; Class.forName("com.mysql.jdbc.Driver").newInstance(); dbcon = DriverManager.getConnection(svr.getURL(), svr.getUN(), svr.getPW()); st = dbcon.createStatement(); st.executeUpdate(strQuery); session.setAttribute("ErrorMessage", "Details Changed"); dbcon.close(); session.setAttribute("ErrorMessage", "Details Changed"); response.sendRedirect("home.jsp"); } catch (Exception ex) { out.println(ex); } }