📄 dbbean.java~3~
字号:
package login;
import java.sql.*;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class DBBean {
private Connection con=null;
private PreparedStatement pstmt=null;
private ResultSet rs=null;
private String loginname=null;
private String username=null;
private String password=null;
private int age=0;
private String address=null;
public DBBean() {
}
public void setLoginname(String loginname) {
this.loginname = loginname;
}
public void setUsername(String username) {
this.username = username;
}
public void setPassword(String password) {
this.password = password;
}
public void setAge(int age) {
this.age = age;
}
public void setAddress(String address) {
this.address = address;
}
public String getLoginname() {
return loginname;
}
public String getUsername() {
return username;
}
public String getPassword() {
return password;
}
public int getAge() {
return age;
}
public String getAddress() {
return address;
}
//连接数据库
public void getConnection(){
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("Jdbc:Odbc:LocalServer", "sa", "");
} catch (Exception ex) {
ex.printStackTrace();
}
}
//关闭连接
public void closeConnection(){
if(rs!=null){
rs.close();
rs=null;
}
if(pstmt!=null){
pstmt.close();
pstmt=null;
}
if(con!=null){
con.close();
con=null;
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -