📄 userinfo.java
字号:
}
}
updated();
}
void changeButton_actionPerformed(ActionEvent e)
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:estate";
connection = DriverManager.getConnection(url);
statement = connection.createStatement();
String sql1= "update room_info set area="+Integer.parseInt(area.getText())+",oname='"+ownername.getText()+"',sex='"+sex.getText()+"',id_num='"+idnum.getText()+"',address='"+addr.getText()+"',phone="+Integer.parseInt(tetel.getText())+" WHERE district_id="+Integer.parseInt(districtid.getText())+" AND building_id="+Integer.parseInt(buildingid.getText())+" AND room_id="+Integer.parseInt(roomid.getText());
statement.executeUpdate(sql1);
}
catch(Exception ex){
JOptionPane.showMessageDialog(UserInfo.this,"修改数据出错","错误",JOptionPane.ERROR_MESSAGE);
//ex.printStackTrace();
}
finally{
try{
if(statement != null){
statement.close();
}
if(connection != null){
connection.close();
}
}
catch(SQLException ex){
System.out.println("\nERROR:---------SQLException--------\n");
System.out.println("Message: "+ ex.getMessage());
System.out.println("SQLState: "+ ex.getSQLState());
System.out.println("ErrorCode: "+ ex.getErrorCode());
}
}
updated();
}
void deleteButton_actionPerformed(ActionEvent e)
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:estate";
connection = DriverManager.getConnection(url);
statement = connection.createStatement();
String sql2= "delete from room_info where district_id="+Integer.parseInt(districtid.getText())+"AND building_id="+Integer.parseInt(buildingid.getText())+"AND room_id="+Integer.parseInt(roomid.getText());//+"area="+Integer.parseInt(area.getText())+"||oname="+ownername.getText()+"||sex="+sex.getText()+"||id_num="+idnum.getText()+"||address="+addr.getText()+"||phone="+Integer.parseInt(tetel.getText());
statement.executeUpdate(sql2);
}
catch(Exception ex){
JOptionPane.showMessageDialog(UserInfo.this,"删除数据出错","错误",JOptionPane.ERROR_MESSAGE);
//ex.printStackTrace();
}
finally{
try{
if(statement != null){
statement.close();
}
if(connection != null){
connection.close();
}
}
catch(SQLException ex){
System.out.println("\nERROR:---------SQLException--------\n");
System.out.println("Message: "+ ex.getMessage());
System.out.println("SQLState: "+ ex.getSQLState());
System.out.println("ErrorCode: "+ ex.getErrorCode());
}
}
updated();
}
void updateButton_actionPerformed(ActionEvent e)
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:estate";
connection = DriverManager.getConnection(url);
statement = connection.createStatement();
String sql3= "select * from room_info";
rSet=statement.executeQuery(sql3);
if(rSet.next()==false)
{
//JOptionPane msg= new JOptionPane();
JOptionPane.showMessageDialog(UserInfo.this,"数据库无相应内容","错误",JOptionPane.ERROR_MESSAGE);
}
else
{
String sql= "select * from room_info";
ResultSet rs=statement.executeQuery(sql);
districtid.setText("");
buildingid.setText("");
roomid.setText("");
area.setText("");
ownername.setText("");
sex.setText("");
idnum.setText("");
addr.setText("");
tetel.setText("");
vector.removeAllElements();
tm.fireTableStructureChanged();
while(rs.next())
{
Vector rec_vector=new Vector();
rec_vector.addElement(String.valueOf(rs.getInt(1)));
rec_vector.addElement(String.valueOf(rs.getInt(2)));
rec_vector.addElement(String.valueOf(rs.getInt(3)));
rec_vector.addElement(String.valueOf(rs.getInt(4)));
rec_vector.addElement(rs.getString(5));
rec_vector.addElement(rs.getString(6));
rec_vector.addElement(rs.getString(7));
rec_vector.addElement(rs.getString(8));
rec_vector.addElement(rs.getString(9));
rec_vector.addElement(rs.getString(10));
rec_vector.addElement(String.valueOf(rs.getInt(11)));
vector.addElement(rec_vector);
}
tm.fireTableStructureChanged();
}
}
catch(Exception ex){
ex.printStackTrace();
}
finally{
try{
if(statement != null){
statement.close();
}
if(connection != null){
connection.close();
}
}
catch(SQLException ex){
System.out.println("\nERROR:---------SQLException--------\n");
System.out.println("Message: "+ ex.getMessage());
System.out.println("SQLState: "+ ex.getSQLState());
System.out.println("ErrorCode: "+ ex.getErrorCode());
}
}
}
void searchButton_actionPerformed(ActionEvent e)
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:estate";
connection = DriverManager.getConnection(url);
statement = connection.createStatement();
// String sql4= "select * from room_info where district_id="+Integer.parseInt(districtid.getText())+"||building_id="+Integer.parseInt(buildingid.getText())+"||room_id="+Integer.parseInt(roomid.getText())+"area="+Integer.parseInt(area.getText())+"||oname='"+ownername.getText()+"'||sex='"+sex.getText()+"'||id_num="+idnum.getText()+"||address="+addr.getText()+"||phone="+Integer.parseInt(tetel.getText());
String sql4= "select * from room_info where oname='"+ownername.getText()+"'";
rSet=statement.executeQuery(sql4);
if(rSet.next()==false)
{
JOptionPane msg= new JOptionPane();
JOptionPane.showMessageDialog(UserInfo.this,"数据库无相应内容","错误",JOptionPane.ERROR_MESSAGE);
vector.removeAllElements();
tm.fireTableStructureChanged();
}
else
{
// String sqll= "select * from room_info where district_id="+Integer.parseInt(districtid.getText())+"||building_id="+Integer.parseInt(buildingid.getText())+"||room_id="+Integer.parseInt(roomid.getText())+"area="+Integer.parseInt(area.getText())+"||oname='"+ownername.getText()+"'||sex='"+sex.getText()+"'||id_num="+idnum.getText()+"||address="+addr.getText()+"||phone="+Integer.parseInt(tetel.getText());
String sqll="select * from room_info where oname='"+ownername.getText()+"'";
ResultSet rs=statement.executeQuery(sqll);
vector.removeAllElements();
tm.fireTableStructureChanged();
while(rs.next())
{
Vector rec_vector=new Vector();
rec_vector.addElement(String.valueOf(rs.getInt(1)));
rec_vector.addElement(String.valueOf(rs.getInt(2)));
rec_vector.addElement(String.valueOf(rs.getInt(3)));
rec_vector.addElement(String.valueOf(rs.getInt(4)));
rec_vector.addElement(rs.getString(5));
rec_vector.addElement(rs.getString(6));
rec_vector.addElement(rs.getString(7));
rec_vector.addElement(rs.getString(8));
rec_vector.addElement(rs.getString(9));
rec_vector.addElement(rs.getString(10));
rec_vector.addElement(String.valueOf(rs.getInt(11)));
vector.addElement(rec_vector);
}
tm.fireTableStructureChanged();
}
}
catch(Exception ex){
ex.printStackTrace();
}
finally{
try{
if(statement != null){
statement.close();
}
if(connection != null){
connection.close();
}
}
catch(SQLException ex){
System.out.println("\nERROR:---------SQLException--------\n");
System.out.println("Message: "+ ex.getMessage());
System.out.println("SQLState: "+ ex.getSQLState());
System.out.println("ErrorCode: "+ ex.getErrorCode());
}
}
}
void updated()
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url="jdbc:odbc:estate";
connection = DriverManager.getConnection(url);
statement = connection.createStatement();
String sql3= "select * from room_info";
rSet=statement.executeQuery(sql3);
if(rSet.next()== true)
{
String sql= "select * from room_info";
ResultSet rs=statement.executeQuery(sql);
vector.removeAllElements();
tm.fireTableStructureChanged();
while(rs.next())
{
Vector rec_vector=new Vector();
rec_vector.addElement(String.valueOf(rs.getInt(1)));
rec_vector.addElement(String.valueOf(rs.getInt(2)));
rec_vector.addElement(String.valueOf(rs.getInt(3)));
rec_vector.addElement(String.valueOf(rs.getInt(4)));
rec_vector.addElement(rs.getString(5));
rec_vector.addElement(rs.getString(6));
rec_vector.addElement(rs.getString(7));
rec_vector.addElement(rs.getString(8));
rec_vector.addElement(rs.getString(9));
rec_vector.addElement(rs.getString(10));
rec_vector.addElement(String.valueOf(rs.getInt(11)));
vector.addElement(rec_vector);
}
tm.fireTableStructureChanged();
}
}
catch(Exception ex){
ex.printStackTrace();
}
finally{
try{
if(statement != null){
statement.close();
}
if(connection != null){
connection.close();
}
}
catch(SQLException ex){
System.out.println("\nERROR:---------SQLException--------\n");
System.out.println("Message: "+ ex.getMessage());
System.out.println("SQLState: "+ ex.getSQLState());
System.out.println("ErrorCode: "+ ex.getErrorCode());
}
}
}
void renewButton_actionPerformed(ActionEvent e)
{
districtid.setText("");
buildingid.setText("");
roomid.setText("");
area.setText("");
ownername.setText("");
sex.setText("");
idnum.setText("");
addr.setText("");
tetel.setText("");
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -