adressadd.java

创建一个数据库dbstu,其中包括下列表： １.student(学号

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
import java.sql.*;
class AdressAdd extends JFrame implements ActionListener{  
String title[]={"学号","宿舍名称","寝室号","楼层电话","电话","邮箱","班主任编号"};
	JTextField xh=new JTextField(10);
	JTextField ssmc=new JTextField(10);
		JTextField qshao=new JTextField(10);
		JTextField lcdh=new JTextField(10);
		JTextField dh=new JTextField(10);
		JTextField yx=new JTextField(10);
		JTextField bzrbh=new JTextField(10);
	
	JButton ok=new JButton("确定");
	JButton cancel=new JButton("取消");
	 String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dbstu";
     Connection con;
        Statement stmt;
        ResultSet rs;
  AdressAdd(){ 
    //this.No=No;
   // if(No==-1)
    setTitle("添加address窗口"); 
    //else setTitle("修改学生档案窗口");
    try{
      Container con=getContentPane();
      con.setLayout(new BorderLayout(0,5));      //设置边界布局
      //stmt=ConnectServer2.con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); //建立可滚动并且可更新的结果集       	
       //rs=stmt.executeQuery("select * from address");      
        
        setSize(450,410);
        JPanel p[]=new JPanel[7];               //建立面板数组,
		for(int i=0;i<7;i++)   
		{	p[i]=new JPanel(new FlowLayout(FlowLayout.LEFT));//建立面板
			p[i].add(new JLabel(title[i])); //建立并添加标签
		}
		p[0].add(xh); 
		p[1].add(ssmc); 
		p[2].add(qshao);
		p[3].add(lcdh);
		p[4].add(dh);
		p[5].add(yx);
		p[6].add(bzrbh);
		
		JPanel top=new JPanel();                 //建立面板top,用于放置p[0]~p[6]
		top.setLayout(new GridLayout(7,1));   //面板top设置网格布局
		//top.setBackground(Color.magenta);
		for(int i=0;i<7;i++)                     //将面板p[0]~p[6]添加到top
			top.add(p[i]);
		JPanel center=new JPanel();//该面板用于放置centerleft,centerright
		center.setLayout(new BorderLayout()); //设置center为边界布局   
    
		JPanel bottom=new JPanel(); //建立面板bottom,用于放置按钮
		bottom.add(ok);bottom.add(cancel);
	  
		con.add(top,"Center");
   	   //	con.add(center,"");
		con.add(bottom,"South"); 
		setVisible(true);
		ok.addActionListener(this);
        cancel.addActionListener(this);
        rs.close();
      }catch(Exception e){e.printStackTrace();}
      setVisible(true);
   }
   boolean loadData(){     //将数据填到组件
     try{
       //combClassID.setSelectedItem(rs.getString(1));
       xh.setText(rs.getString(1));
       ssmc.setText(rs.getString(2));       
       qshao.setText(rs.getString(3));
       
       lcdh.setText(rs.getString(4));
       dh.setText(rs.getString(5));  
       yx.setText(rs.getString(6)); 
       bzrbh.setText(rs.getString(7));          
     }catch(SQLException e){e.printStackTrace();return false;}
     return true;	
   }
   public void actionPerformed(ActionEvent e){
     try{
       if(e.getSource()==ok){
       	try {//
           Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
       } catch(java.lang.ClassNotFoundException ef) {
            System.err.print("ClassNotFoundException: ");
            System.err.println(ef.getMessage());
        }
        con= DriverManager.getConnection(url, "sa", "");
			stmt = con.createStatement();
         String sex;
         //int classID;
        // Statement stmt=ConnectServer2.con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 	
  //ResultSet rs=stmt.executeQuery("select * from address");//name='"+combClassID.getSelectedItem()+"'"
         rs.first();
         //txtNo=rs.getSting(1);
        
        // if(checkIsMember.isSelected()) isMember="Y";
        // else isMember="N";
         String sql;
         
        // if(No==-1)
         {              //添加记录Integer.parseInt()
           sql="insert into address(学号,宿舍名称,寝室号,楼层电话,电话,邮箱,班主任编号)";
           sql=sql+" values("+xh.getText()+",'" +ssmc.getText()+"','";
           sql=sql+"','"+qshao.getText()+"','"+lcdh.getText()+"','";
           sql=sql+dh.getText()+"','"+yx.getText()+bzrbh.getText()+"')";
         System.out.println(sql);
         }
        /* else{                   //修改记录
           sql="update xsda set classID="+classID;
           sql=sql+",Name='"+txtName.getText();
           sql=sql+"',sex='"+sex+"',Age='"+txtAge.getText();
           sql=sql+"',isMember='"+isMember;
           sql=sql+"',address='"+txtAddress.getText();
           sql=sql+"',resume='"+txtResume.getText()+"' where no="+No;
         }*/
         stmt.executeUpdate(sql);  //执行SQL语句
       } 
       else if(e.getSource()==cancel) dispose();
     }catch(Exception ee){ee.printStackTrace();}
   }
   /*public static void main(String args[]){ 
     JFrame.setDefaultLookAndFeelDecorated(true);
     Font font = new Font("JFrame", Font.PLAIN, 14);
     Enumeration keys = UIManager.getLookAndFeelDefaults().keys();
     while (keys.hasMoreElements()) {
       Object key = keys.nextElement();
       if(UIManager.get(key) instanceof Font)UIManager.put(key, font);
     }
    
	 new AdressAdd();    //-1添加新记录的调用方法
	// new StudentDataUpdate(2);        //修改学号为2的记录
   }*/
}