Download

Download

DBSearch

 import java.sql.ResultSet;

import java.sql.Statement;

public class DBSearch {

Statement stmt;

ResultSet rs;

public ResultSet searchLogin(String usName) {

try {

stmt = DBConnection.getStatementConnection();

String name = usName;

//Execute the Query

rs = stmt.executeQuery("SELECT * FROM login where username='" + name + "'");

} catch (Exception e) {

e.printStackTrace();

}

return rs;

}

}

DBConnection

 import com.mysql.jdbc.PreparedStatement;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

public class DBConnection {

static Connection conn;

static Statement stat = null;

public static Statement getStatementConnection() {

try {

String url = "jdbc:mysql://localhost:3306/sms";

conn = DriverManager.getConnection(url, "root", "");

stat = conn.createStatement();

} catch (Exception e) {

e.printStackTrace();

}

return stat;

}

public static void closeCon() throws SQLException {

conn.close();

}

}