📄 house.java
字号:
yfffh=rs1.getInt("fangh");
yffmji=rs1.getInt("mianj");
System.out.print("fsff "+yfffh+yffmji+yffzc);
pstmt=con.prepareStatement("INSERT INTO yffwenjian VALUES(?,?,?,?,?,?,?)");
pstmt.setString(1,yffnam);
pstmt.setString(2,yffbm);
pstmt.setInt(3,yffzc);
pstmt.setInt(4,yffnum);
pstmt.setInt(5,yffjf);
pstmt.setInt(6,yfffh);
pstmt.setInt(7,yffmj);
pstmt.executeUpdate();
// String sql="delete from tjsqbiao where bumensq=? and name=?";
pstmt1=con.prepareStatement("delete from tjsqbiao where bumensq='"+yffnam+"' and name='"+yffnam+"'");
// pstmt1.setString(1,yffbm);
// pstmt1.setString(2,yffnam);
pstmt1.executeUpdate();
pstmt3=con.prepareStatement("delete from kfwenjian where fangh='"+yfffh+"' ");
pstmt3.executeUpdate();
/* stmt1=con.createStatement();
rs1 = stmt.executeQuery("SELECT * from tjsqbiao ");
while(rs1.next()){
delnam=rs1.getString("name");
pstmt4=con.prepareStatement("delete from kfwenjian where fangh='"+yfffh+"' ");
pstmt4.executeUpdate();
}*/
new sqtishiFrame();
break;
}
else{
new sqsbFrame();
System.out.print("dasfasf");
new sqsbFrame();
}
}
}
con.close(); //关闭与数据库的连接
}catch( Exception e ) {
e.printStackTrace();
}
}
}
class tishiFrame extends JFrame
{
JPanel tssq1=new JPanel();
JPanel tssq2=new JPanel();
JPanel tssq3=new JPanel();
public tishiFrame(){
setLocation(200,150);
add(tssq1);
tssq1.add(tssq2,BorderLayout.CENTER);
tssq1.add(tssq3,BorderLayout.NORTH);
String tsnam= shenqingFrame.nams;
Label tstext=new Label(tsnam+"你的住房申请已接受");
//String xinxi="你的申请已接受";
tssq2.add(tstext);
setSize(200, 100);
setVisible(true);
}
}
class sqsbFrame extends JFrame
{
JPanel tssq1=new JPanel();
JPanel tssq2=new JPanel();
JPanel tssq3=new JPanel();
public sqsbFrame(){
setLocation(200,150);
add(tssq1);
tssq1.add(tssq2,BorderLayout.CENTER);
tssq1.add(tssq3,BorderLayout.NORTH);
String tsnam= shenqingFrame.nams;
Label tstext=new Label(tsnam+"你的住房申请失败");
//String xinxi="你的申请已接受";
tssq2.add(tstext);
setSize(200, 100);
setVisible(true);
}
}
class sqtishiFrame extends JFrame
{
JPanel tssq1=new JPanel();
JPanel tssq2=new JPanel();
JPanel tssq3=new JPanel();
public sqtishiFrame(){
setLocation(200,150);
add(tssq1);
tssq1.add(tssq2,BorderLayout.CENTER);
tssq1.add(tssq3,BorderLayout.NORTH);
String tsnam=fenfang.yffnam;
int tsnum=fenfang.yfffh;
Label tstext=new Label(tsnam+"你的住房申请已批准，房号是："+tsnum);
//String xinxi="你的申请已接受";
tssq2.add(tstext);
setSize(250, 100);
setVisible(true);
}
}
class dfsqbiao
{
public static String namd1;
public static int ccmj;
public dfsqbiao()
{
String bmd1= huanfangFrame.bmd;
String zcd1= huanfangFrame.zcd;
namd1= huanfangFrame.namd;
String numd1= huanfangFrame.numd;
String yhfd1= huanfangFrame.yfhd;
String ymjd1= huanfangFrame.ymjd;
String yqmjd1= huanfangFrame.yqmjd;
try {
Statement stmt;
PreparedStatement pstmt;
ResultSet rs;
Statement stmt1;
ResultSet rs1;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:AADSN";
Connection con = DriverManager.getConnection (url,"System","sys");
stmt1=con.createStatement();
rs1 = stmt1.executeQuery("SELECT * from yffwenjian where fangh='"+yhfd1+"'");
while(rs1.next())
{
ccmj=rs1.getInt("mianj");
}
pstmt=con.prepareStatement("INSERT INTO dfbiao ("
+ "bumendf,namdf,zcdf,numdf,zfjf,yfmj,yfangh,yqmj) VALUES(?,?,?,?,?,?,?,?)");
String dfbm=bmd1;
String dfnam=namd1;
try{
Integer dfzcd=Integer.parseInt(zcd1);
Integer dfnum=Integer.parseInt(numd1);
Integer dffh=Integer.parseInt(yhfd1);
Integer dfymj=Integer.parseInt(ymjd1);
Integer dfyqmj=Integer.parseInt(yqmjd1);
Integer dfjf=(dfzcd*dfnum+4);
pstmt.setString(1,dfbm);
pstmt.setString(2,dfnam);
pstmt.setInt(3,dfzcd);
pstmt.setInt(4,dfnum);
pstmt.setInt(5,dfjf);
pstmt.setInt(6,dfymj);
pstmt.setInt(7,dffh);
pstmt.setInt(8,dfyqmj);
pstmt.execute();
}catch(NumberFormatException q)
{
// q.printStackTrace();
}
con.close(); //关闭与数据库的连接
}catch( Exception e ) {
e.printStackTrace();
}
}
}
class dfsqshiFrame extends JFrame
{
JPanel tssq1=new JPanel();
JPanel tssq2=new JPanel();
JPanel tssq3=new JPanel();
public dfsqshiFrame(){
setLocation(200,150);
add(tssq1);
tssq1.add(tssq2,BorderLayout.CENTER);
tssq1.add(tssq3,BorderLayout.NORTH);
String tsnam=dfsqbiao.namd1 ;
Label tstext=new Label(tsnam+"你的住房申请已接受");
//String xinxi="你的申请已接受";
tssq2.add(tstext);
setSize(200, 100);
setVisible(true);
}
}
class dfbiao{
String dfbm;
int dfzc;
public static String dfnam;
int dfnum;
int dfmj;
int dfjf;
int dfh;
int dfsqmj;
public static int dffh;
int i;
public dfbiao(){
try {
Statement stmt;
PreparedStatement pstmt;
PreparedStatement pstmt1;
PreparedStatement pstmt2;
PreparedStatement pstmt3;
PreparedStatement pstmt4;
ResultSet rs;
ResultSet rs1;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:AADSN";
Connection con = DriverManager.getConnection (url,"System","sys");
System.out.println("URL: " + url);
System.out.println("Connection: " + con);
System.out.print("aaaaaaaaaaaaaaaaaaa");
stmt=con.createStatement();
rs = stmt.executeQuery("SELECT * from dfbiao");
while(rs.next())
{
dfbm=rs.getString("bumendf");
dfnam=rs.getString("namdf");
dfzc=rs.getInt("zcdf");
dfnum=rs.getInt("numdf");
dfjf= rs.getInt("zfjf");
dfmj= rs.getInt("yfmj");
dfh=rs.getInt("yfangh");
dfsqmj=rs.getInt("yqmj");
dfjf=(dfzc*dfnum+4);
String sql = "select * from kfwenjian where mianj=? and zdjifen<?";
pstmt1=con.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
pstmt1.setInt(1,dfsqmj);
pstmt1.setInt(2,dfjf);
rs1=pstmt1.executeQuery();
// rs1=stmt.executeQuery("select fangh,mianj,zdjifen from kfwenjian where zdjifen<'"+yffjf+"' and mianj='"+yffmj+"'");
i=0;
while(rs1.next()){
i++;
if(i==1){
dffh=rs1.getInt("fangh");
//yffmji=rs1.getInt("mianj");
// zdjf=rs1.getInt("zdjifen");
pstmt=con.prepareStatement("INSERT INTO yffwenjian ("
+ "name,bumen,zc,num,zffs,fangh,mianj) VALUES(?,?,?,?,?,?,?)");
pstmt.setString(1,dfnam);
pstmt.setString(2,dfbm);
pstmt.setInt(3,dfzc);
pstmt.setInt(4,dfnum);
pstmt.setInt(5,dfjf);
pstmt.setInt(6,dffh);
pstmt.setInt(7,dfsqmj);
pstmt.executeUpdate();
pstmt4=con.prepareStatement("INSERT INTO kfwenjian ("
+ "fangh,mianj,zdjifen,zjin) VALUES(?,?,?,?)");
int zdjf=(dfsqmj/10);
int mianj=dfsqbiao.ccmj;
pstmt4.setInt(1,dfh);
pstmt4.setInt(2,mianj);
pstmt4.setInt(3,zdjf);
pstmt4.setInt(4,mianj);
pstmt4.executeUpdate();
pstmt3=con.prepareStatement("delete from kfwenjian where fangh='"+dffh+"' ");
pstmt3.executeUpdate();
pstmt4=con.prepareStatement("delete from yffwenjian where fangh='"+dfh+"' ");
pstmt4.executeUpdate();
break;
}
else {
System.out.print("aaaaaaaaaaaaaaaaaaa");
}
}
}
con.close(); //关闭与数据库的连接
}catch( Exception e ) {
e.printStackTrace();
}
}
}
class dftishiFrame extends JFrame
{
JPanel tssq1=new JPanel();
JPanel tssq2=new JPanel();
JPanel tssq3=new JPanel();
public dftishiFrame(){
setLocation(200,150);
add(tssq1);
tssq1.add(tssq2,BorderLayout.CENTER);
tssq1.add(tssq3,BorderLayout.NORTH);
String tsnam=dfbiao.dfnam;
int tsnum=dfbiao.dffh;
Label tstext=new Label(tsnam+"你的住房申请已批准，房号是："+tsnum);
//String xinxi="你的申请已接受";
tssq2.add(tstext);
setSize(250, 100);
setVisible(true);
}
}
class deletesq{
public deletesq(){
try {
PreparedStatement pstmt;
ResultSet rs;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:AADSN";
Connection con = DriverManager.getConnection (url,"System","sys");
pstmt=con.prepareStatement("delete from yff_tj;");
pstmt.executeUpdate();
con.close();
}
catch( Exception e ) {
// e.printStackTrace();
}
}
}
class deletedf{
public deletedf(){
try {
PreparedStatement pstmt;
ResultSet rs;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:AADSN";
Connection con = DriverManager.getConnection (url,"System","sys");
pstmt=con.prepareStatement("delete from dfbiao;");
pstmt.executeUpdate();
con.close();
}
catch( Exception e ) {
e.printStackTrace();
}
}
}
class tfbiao
{
public tfbiao()
{
String tfbm1= tuifangFrame.tfbm;
String tffh1= tuifangFrame.tffh;
String tfmj1= tuifangFrame.tfmj;
int zdjf;
int zfzj;
try {
Statement stmt;
PreparedStatement pstmt;
PreparedStatement pstmt1;
// ResultSet rs;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:AADSN";
Connection con = DriverManager.getConnection (url,"System","sys");
try{
Integer tffh2=Integer.parseInt(tffh1);
Integer tfmj2=Integer.parseInt(tfmj1);
zdjf=(tfmj2/10);
zfzj=tfmj2;
pstmt1=con.prepareStatement("INSERT INTO kfwenjian ("
+ "fangh,mianj,zdjifen,zjin) VALUES(?,?,?,?)");
pstmt1.setInt(1,tffh2);
pstmt1.setInt(2,tfmj2);
pstmt1.setInt(3,zdjf);
pstmt1.setInt(4,zfzj);
pstmt1.execute();
pstmt=con.prepareStatement("delete from yffwenjian where fangh='"+tffh1+"' ");
pstmt.executeUpdate();
new tftsshiFrame();
}catch(NumberFormatException q)
{
// q.printStackTrace();
}
con.close(); //关闭与数据库的连接
}catch( Exception e ) {
e.printStackTrace();
}
}
}
class tftsshiFrame extends JFrame
{
JPanel tssq1=new JPanel();
JPanel tssq2=new JPanel();
JPanel tssq3=new JPanel();
public tftsshiFrame(){
setLocation(200,150);
add(tssq1);
tssq1.add(tssq2,BorderLayout.CENTER);
tssq1.add(tssq3,BorderLayout.NORTH);
Label tstext=new Label("你的退房申请已接受");
//String xinxi="你的申请已接受";
tssq2.add(tstext);
setSize(200, 100);
setVisible(true);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -