📄 personbean.java
字号:
package myBean;
import java.io.*;
import java.sql.*;
import java.util.*;
public class PersonBean implements Serializable {
private String name;
private String sex;
private int age;
private String tel;
private void readObject(ObjectInputStream ois) throws IOException,
ClassNotFoundException {
ois.defaultReadObject();
}
private void writeObject(ObjectOutputStream oos) throws IOException {
oos.defaultWriteObject();
}
public void setName(String name) {
this.name = name;
}
public void setSex(String sex) {
this.sex = sex;
}
public void setAge(int age) {
this.age = age;
}
public void setTel(String tel) {
this.tel = tel;
}
public String getName() {
return name;
}
public String getSex() {
return sex;
}
public int getAge() {
return age;
}
public String getTel() {
return tel;
}
private Connection getConnection()
{
Connection con=null;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/helloBeijing?user=chen&password=admin&useUnicode=true&characterEncoding=GB2312");
}
catch(Exception e){
e.printStackTrace(System.err);
}
return con;
}
public ResultSet query(String sql) {
ResultSet rs =null;
try {
Connection conn = getConnection();
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println(ex.getMessage());
}
return rs;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -