Advertisement
Guest User

Untitled

a guest
Mar 28th, 2019
191
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.77 KB | None | 0 0
  1. final String USER = "root";
  2.         final String PASS = "1012";
  3.        
  4.         Connection conn = null;
  5.         Statement stmt = null;
  6.        
  7.         try{
  8.             //STEP 2: Register JDBC driver
  9.             Class.forName("com.mysql.cj.jdbc.Driver");
  10.  
  11.             //STEP 3: Open a connection
  12.             System.out.println("Connecting to database...");
  13.             conn = DriverManager.getConnection(DB_URL,USER,PASS);
  14.            
  15.             //STEP 4: Execute a query
  16.             System.out.println("Creating statement...");
  17.             stmt = conn.createStatement();
  18.             String sql;
  19.             sql = "SELECT * FROM tb_usuario where login_usuario ='" + login_informado + "' and senha_usuario='" + password_informado + "'";
  20.             ResultSet rs = stmt.executeQuery(sql);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement