调用函数:
package action;
import com.opensymphony.xwork2.ActionSupport;
public class Login extends ActionSupport {
private static final long serialVersionUID = 1L;
private String username;
private String password;
public String login() throws Exception {
DB db = new DB();
if(username.equals(db.name) && password.equals(db.word)){
return "welcome";
}else{
return "false";
}
}
public String cancel() throws Exception {
return "cancel";
} public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}被调用函数:
package action;
import java.sql.*;public class DB {
public static void main(String[] args) {
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch (ClassNotFoundException e) {
e.printStackTrace();
}
try{
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String url="jdbc:oracle:thin:@172.16.100.225:1521:orcl";
String user="CBD";
String password="CBD";
con = DriverManager.getConnection(url,user,password);
stmt = con.createStatement();
rs = stmt.executeQuery("select * from P_LOGIN");
while (rs.next()) {
String name = rs.getString("USERNAME");
String word = rs.getString("PASSWORD");
System.out.println(name + ":" +word );
}
stmt.close();
con.close();
rs.close(); }catch(SQLException e){
e.printStackTrace();
}
}
}
package action;
import com.opensymphony.xwork2.ActionSupport;
public class Login extends ActionSupport {
private static final long serialVersionUID = 1L;
private String username;
private String password;
public String login() throws Exception {
DB db = new DB();
if(username.equals(db.name) && password.equals(db.word)){
return "welcome";
}else{
return "false";
}
}
public String cancel() throws Exception {
return "cancel";
} public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}被调用函数:
package action;
import java.sql.*;public class DB {
public static void main(String[] args) {
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch (ClassNotFoundException e) {
e.printStackTrace();
}
try{
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String url="jdbc:oracle:thin:@172.16.100.225:1521:orcl";
String user="CBD";
String password="CBD";
con = DriverManager.getConnection(url,user,password);
stmt = con.createStatement();
rs = stmt.executeQuery("select * from P_LOGIN");
while (rs.next()) {
String name = rs.getString("USERNAME");
String word = rs.getString("PASSWORD");
System.out.println(name + ":" +word );
}
stmt.close();
con.close();
rs.close(); }catch(SQLException e){
e.printStackTrace();
}
}
}
import com.opensymphony.xwork2.ActionSupport;
public class Login extends ActionSupport {
private static final long serialVersionUID = 1L;
private String username;
private String password;
public String login() throws Exception {
DB db = new DB();
if(db.getUser(username,password){
return "welcome";
}else{
return "false";
}
}
public String cancel() throws Exception {
return "cancel";
}public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
第二个package action;
import java.sql.*;public class DB {
public Boolean getUser(String name,String pwd) {
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}catch (ClassNotFoundException e) {
e.printStackTrace();
}
try{ Connection con = null;
Statement stmt = null;
ResultSet rs = null;
boolean result=false;String url="jdbc:oracle:thin:@172.16.100.225:1521:orcl";
String user=name;
String password=pwd;
stmt = con.createStatement();
rs = stmt.executeQuery("select * from P_LOGIN where username="+user+" and password="+password+" ");
if(rs!=null){
result=true;
}stmt.close();
con.close();
rs.close();}catch(SQLException e){
e.printStackTrace();
}
}
return result;
}