学期学会的一些代码23333原创

学期学会的一些代码23333原创

第一点DBH
package util;

第一点DBH

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * 连接数据库
 * 
 * @author admin
 *
 */

public class DBHelper {
// 驱动
static String cname = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
	// 连接数据库
static String url = "jdbc:sqlserver://localhost:1433;DatabaseName=G2002";

// 1、加载驱动
static {		
	try {
		Class.forName(cname);
	} catch (ClassNotFoundException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
}

// 2、连接数据库
// 静态方法名字：getCon
// 参数：无
// 返回值：Connection
// peDBHelr.getCon();
/**
 * 连接数据库
 * 
 * @return con 连接对象
 */
public static Connection getCon() {
	Connection con = null;
	try {
		con = DriverManager.getConnection(url, "sa", "zkingedu");
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	return con;
}

//3、关闭数据库
/**
 * 关闭数据库
 * @param con 连接数据库对象
 * @param ps 执行对象
 * @param rs 结果集
 */
public static void myColse(Connection con,PreparedStatement ps,ResultSet rs) {
	 try {
		if(con!=null || con.isClosed()) {
			 con.close();
		}
		if(ps!=null || ps.isClosed()) {
			ps.close();
		}
		if(rs!=null || rs.isClosed()) {
			rs.close();
		}
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	
}

/**
 * 关闭数据库
 * @param con 连接数据库对象
 * @param ps 执行对象
 */
public static void myColse(Connection con,PreparedStatement ps) {
	 try {
		if(con!=null || con.isClosed()) {
			 con.close();
		}
		if(ps!=null || ps.isClosed()) {
			ps.close();
		}
		
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	
}
/**
 * 关闭数据库
 * @param con 连接数据库对象
 */
public static void myColse(Connection con) {
	 try {
		if(con!=null || con.isClosed()) {
			 con.close();
		}
		
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	
}
//	public static void main(String[] args) {
//		Connection con = getCon();
	//		System.out.println(con);
//	}

}

然后studao`package com.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
	import java.util.ArrayList;

	import entity.Student;
import util.DBHelper;

public class StudentDao {

// 查询所有：printAll
// 参数：无
// 返回值：student-集合
public ArrayList<Student> printAll() {
	ArrayList<Student> list = new ArrayList<Student>();

	try {
		// 1.连接数据库
		Connection con = DBHelper.getCon();
		// 2.获取执行对象
		String sql = "select * from tb_stu";
		PreparedStatement ps = con.prepareStatement(sql);
		// 3.执行sql语句
		ResultSet rs = ps.executeQuery();
		while (rs.next()) {
			int sid = rs.getInt(1);// 学生学号
			String sname = rs.getString(2);// 学生姓名
			String sex = rs.getString(3);// 学生性别
			String brithday = rs.getString(4);// 出生日期
			String hobby = rs.getString(5);// 爱好
			String address = rs.getString(6);// 地址

			Student s = new Student(sid, sname, sex, brithday, hobby, address);

			list.add(s);

		}
		// 4.关闭连接
		DBHelper.myColse(con, ps, rs);

	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}

	return list;
}


// 查询所有：printAll
// 参数：String type，String str
// 返回值：student-集合
public ArrayList<Student> printAll(String type,String str) {
	ArrayList<Student> list = new ArrayList<Student>();

	try {
		// 1.连接数据库
		Connection con = DBHelper.getCon();
		// 2.获取执行对象
		String sql = "select * from tb_stu where "+type+" like '%"+str+"%'";
		PreparedStatement ps = con.prepareStatement(sql);
		// 3.执行sql语句
		ResultSet rs = ps.executeQuery();
		while (rs.next()) {
			int sid = rs.getInt(1);// 学生学号
			String sname = rs.getString(2);// 学生姓名
			String sex = rs.getString(3);// 学生性别
			String brithday = rs.getString(4);// 出生日期
			String hobby = rs.getString(5);// 爱好
			String address = rs.getString(6);// 地址
			Student s = new Student(sid, sname, sex, brithday, hobby, address);
			list.add(s);
		}
		// 4.关闭连接
		DBHelper.myColse(con, ps, rs);
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	return list;
}



//	单个查询：printAll
//	参数：int id
	//	返回值：Student stu
	public Student printAll(int id) {
	Student stu = null;

	try {
		// 1.连接数据库
		Connection con = DBHelper.getCon();
		// 2.获取执行对象
		String sql = "select * from tb_stu where sid = " +id;
		PreparedStatement ps = con.prepareStatement(sql);
		// 3.执行sql语句
		ResultSet rs = ps.executeQuery();
		while (rs.next()) {
			int sid = rs.getInt(1);// 学生学号
			String sname = rs.getString(2);// 学生姓名
			String sex = rs.getString(3);// 学生性别
			String brithday = rs.getString(4);// 出生日期
			String hobby = rs.getString(5);// 爱好
			String address = rs.getString(6);// 地址

			stu = new Student(sid, sname, sex, brithday, hobby, address);

		}
		// 4.关闭连接
		DBHelper.myColse(con, ps, rs);

	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}

	return stu;
}

// 删除：delById
// 参数：int sid
// 返回值：int n-影响数据表的行

public int delById(int sid) {
	int n = 0;
	try {
		// 1.连接数据库
		Connection con = DBHelper.getCon();

		// 2.获取执行对象
		// String sql = "delete tb_stu where sid = '"+sid+"'";//sid是字符串
		String sql = "delete tb_stu where sid = " + sid;
		PreparedStatement ps = con.prepareStatement(sql);
		// 3.执行sql语句
		n = ps.executeUpdate();
		// 4.关闭对象
		DBHelper.myColse(con, ps);
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	return n;
}


//	增加：add
//	参数：Student stu
//	返回值：int n

public int add(Student stu){
	int n = 0;
	try {

		Connection con = DBHelper.getCon();
		String sql = "insert into tb_stu values(?,?,?,?,?)";
		PreparedStatement ps = con.prepareStatement(sql);
		ps.setString(1, stu.getSname());
		ps.setString(2, stu.getSex());
		ps.setString(3, stu.getBrithday());
		ps.setString(4, stu.getHobby());
		ps.setString(5, stu.getAddress());
		n = ps.executeUpdate();
		DBHelper.myColse(con, ps);
		
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	return n;		
}	

//	修改：updateById
//	参数：int sid，Student stu
//	返回值；int n

public int updateById(int sid,Student stu){
	int n = 0;
	try {
		Connection con = DBHelper.getCon();
		String sql = "update tb_stu set sname = ?,sex = ?,brithday = ? ,hobby = ?,address=? where sid = ?";
		
		PreparedStatement ps = con.prepareStatement(sql);
		ps.setString(1, stu.getSname());
		ps.setString(2, stu.getSex());
		ps.setString(3, stu.getBrithday());
		ps.setString(4, stu.getHobby());
		ps.setString(5, stu.getAddress());
		ps.setInt(6, sid);
		
		n = ps.executeUpdate();
		
		DBHelper.myColse(con, ps);
		
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	return n;		
}	

}

还要stu
package com.entiey;
/**
* 学生实体类
* @author admin
*
*/
public class Student {

private int sid;//学生学号
private String sname;//学生姓名
private String sex;//学生性别	
private String brithday;//出生日期	
private String hobby;//爱好
private String address;//地址

public Student() {}

public Student( String sname, String sex, String brithday, String hobby, String address) {
	this(0, sname, sex, brithday, hobby, address);
}
public Student(int sid, String sname, String sex, String brithday, String hobby, String address) {
	this.sid = sid;
	this.sname = sname;
	this.sex = sex;
	this.brithday = brithday;
	this.hobby = hobby;
	this.address = address;
}

public int getSid() {
	return sid;
}

public void setSid(int sid) {
	this.sid = sid;
}

public String getSname() {
	return sname;
}

public void setSname(String sname) {
	this.sname = sname;
}

public String getSex() {
	return sex;
}

public void setSex(String sex) {
	this.sex = sex;
}

public String getBrithday() {
	return brithday;
}

public void setBrithday(String brithday) {
	this.brithday = brithday;
}

public String getHobby() {
	return hobby;
}

public void setHobby(String hobby) {
	this.hobby = hobby;
}

public String getAddress() {
	return address;
}

public void setAddress(String address) {
	this.address = address;
}

@Override
public String toString() {
	return "Student [sid=" + sid + ", sname=" + sname + ", sex=" + sex + ", brithday=" + brithday + ", hobby="
			+ hobby + ", address=" + address + "]";
}





}

`

首先senter`

public class MyCenter extends JFrame{

public static void main(String[] args) {
	new MyCenter();
}

//上层
private JPanel jpa=new JPanel();
private JComboBox jcba=new JComboBox<>();
private JTextField jtfa= new JTextField(15);
private JButton jba=new JButton("查询");

//定义表格
private JTable jta=new JTable();
//表格模式
private DefaultTableModel dtm=new DefaultTableModel();
//中层
private JScrollPane jsp=new JScrollPane(jta);


//下层
private JPanel jpc=new JPanel();
private JButton jbb=new JButton("新增");
private JButton jbc=new JButton("修改");
private JButton jbd=new JButton("删除");
private JButton jbe=new JButton("退出");


StuDao sd=new StuDao();



public MyCenter() {
	this.setTitle("用户中心");
	this.setSize(400,300);
	this.setLocationRelativeTo(null);
	this.setDefaultCloseOperation(3);
	//给下拉框添加值
	jcba.addItem("用户名");
	jcba.addItem("地址");
	jcba.addItem("爱好");
	
	//上层布局
	jpa.add(jcba);
	jpa.add(jtfa);
	jpa.add(jba);
	
	//中层布局
	jta.setModel(dtm);
	dtm.addColumn("学号");
	dtm.addColumn("姓名");
	dtm.addColumn("密码");
	dtm.addColumn("性别");
	dtm.addColumn("爱好");
	dtm.addColumn("地址");
	dtm.addColumn("备注");
	
	//调用方法进行表格的数据绑定

	bindData("sname", "");
	
	//下层布局
	jpc.add(jbb);
	jpc.add(jbc);
	jpc.add(jbd);
	jpc.add(jbe);
	
	
	//查询的按钮事件
	jba.addActionListener(new ActionListener() {
		
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			//获取下拉框的值
			String name="sname";
			String ss = jcba.getSelectedItem().toString();
			if(ss.equals("地址")) {
				name="address";
			}
			else if(ss.equals("爱好")) {
				name="hobby";
			}
			
			String str=jtfa.getText();
			bindData(name,str);
		}
	});
	
	//新增按钮事件
	jbb.addActionListener(new ActionListener() {
		
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			new MyAdd(MyCenter.this);
		}
	});
	
	//删除按钮事件
	jbd.addActionListener(new ActionListener() {
		
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			//得到被选择的行
			int a = jta.getSelectedRow();
			if(a!=-1) {
				int b = JOptionPane.showConfirmDialog(null, "是否确认删除？");
				if(b==0) {
					//得到被选择的行的第一列(sid)
					String sid = dtm.getValueAt(a, 0).toString();
					int n = sd.delStu(sid);
					if(n>0) {
						bindData("sname", "");
					}
					else {
						JOptionPane.showMessageDialog(null, "删除失败！");
					}
				}
			}else {
				JOptionPane.showMessageDialog(null, "请选择一行");
			}
		}
	});
	//修改按钮事件
	jbc.addActionListener(new ActionListener() {
		
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			int a=jta.getSelectedRow();
			if(a!=-1) {
				String sid=dtm.getValueAt(a, 0).toString();
				//根据id查询单个对象信息
				Stu s = sd.getById(sid);
				//调用修改的界面，同时传递对象过去
				new MyUpdate(MyCenter.this, s);
			}
			else {
				JOptionPane.showMessageDialog(null, "请选择一行");
			}
		}
	});
	
	//退出按钮事件
	jbe.addActionListener(new ActionListener() {
		
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			System.exit(1);
		}
	});
	
	
	
	this.getContentPane().add(jpa,"North");
	this.getContentPane().add(jsp,"Center");
	this.getContentPane().add(jpc,"South");
	this.setVisible(true);
}

//给表格绑定数据
public void bindData(String name,String str) {
	//得到表格内数据的行数
	int rowCount = jta.getRowCount();
	//循环清除
	for(int i=0;i<rowCount;i++) {
		//清除表模式内的数据
		dtm.removeRow(0);
	}
	if(str==null) {
		str="";
	}
	List<Stu> stuList = sd.getAll(name,str);
	for (Stu s : stuList) {
		Vector vc=new Vector<>();
		vc.add(s.getSid());
		vc.add(s.getSname());
		vc.add(s.getPwd());
		vc.add(s.getSex());
		vc.add(s.getHobby());
		vc.add(s.getAddress());
		vc.add(s.getRemark());
		dtm.addRow(vc);
	}
}
}

然后add`package ui;

public class MyAdd extends JFrame{

private JPanel jpa=new JPanel();
//定义用户名
private JLabel jla=new JLabel("用户名：");
private JTextField jtfa=new JTextField(15);
//定义密码
private JLabel jlb=new JLabel("密码：");
private JPasswordField jpfa=new JPasswordField(15);
//定义性别
private JLabel jlc=new JLabel("性别：");
private JRadioButton jra=new JRadioButton("男");
private JRadioButton jrb=new JRadioButton("女");
private ButtonGroup bg=new ButtonGroup();
//定义爱好
private JLabel jld=new JLabel("爱好：");
private JCheckBox jcba=new JCheckBox("吃饭");
private JCheckBox jcbb=new JCheckBox("睡觉");
private JCheckBox jcbc=new JCheckBox("游戏");
//定义地址
private JLabel jle=new JLabel("地址：");
private JComboBox  jcbba=new JComboBox<>();
//定义备注
private JLabel jlf=new JLabel("备注");
private JTextArea jta=new JTextArea(5,20);
private JScrollPane jsp=new JScrollPane(jta);

//定义按钮
private JButton jba=new JButton("确定");
private JButton jbb=new JButton("重置");
private MyCenter mc=null;
public MyAdd(MyCenter mc) {
	if(mc!=null) {
		this.mc=mc;
	}
	this.setTitle("新增");
	this.setSize(350,500);
	this.setLocationRelativeTo(null);
	this.setDefaultCloseOperation(3);
	
	//给按钮组添加控件
	bg.add(jra);
	bg.add(jrb);
	//男性默认被选择
	jra.setSelected(true);
	
	//给下拉框添加值
	jcbba.addItem("湖南省");
	jcbba.addItem("湖北省");
	jcbba.addItem("海南省");
	jcbba.addItem("河南省");
	//设定容器布局为空
	jpa.setLayout(null);
	//用户名
	jla.setBounds(50, 50, 60, 30);
	jtfa.setBounds(110, 50, 120, 30);
	//密码
	jlb.setBounds(50, 90, 60, 30);
	jpfa.setBounds(110, 90, 120, 30);
	//性别
	jlc.setBounds(50, 130, 60, 30);
	jra.setBounds(110, 130, 40, 30);
	jrb.setBounds(160, 130, 40, 30);
	//爱好
	jld.setBounds(50, 170, 60, 30);
	jcba.setBounds(100, 170, 60, 30);
	jcbb.setBounds(160, 170, 60, 30);
	jcbc.setBounds(220, 170, 60, 30);
	//地址
	jle.setBounds(50, 210, 60, 30);
	jcbba.setBounds(110, 210, 80, 30);
	//备注
	jlf.setBounds(50, 250, 60, 30);
	jsp.setBounds(110, 250, 160, 100);
	//备注
	jba.setBounds(70, 370, 60, 30);
	jbb.setBounds(190, 370, 60, 30);
	
	
	

	jpa.add(jla);
	jpa.add(jlb);
	jpa.add(jlc);
	jpa.add(jld);
	jpa.add(jle);
	jpa.add(jlf);

	jpa.add(jtfa);
	jpa.add(jpfa);
	jpa.add(jra);
	jpa.add(jrb);
	jpa.add(jcba);
	jpa.add(jcbb);
	jpa.add(jcbc);
	jpa.add(jcbba);
	jpa.add(jsp);
	
	jpa.add(jba);
	jpa.add(jbb);
	
	//确定按钮事件
	jba.addActionListener(new ActionListener() {
		
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
			//获取所有控件的值
			//用户名
			String sname=jtfa.getText();
			//密码
			String pwd=jpfa.getText();
			//性别
			String sex="男";
			if(jrb.isSelected()) {
				sex="女";
			}
			//爱好
			String hobby="";
			if(jcba.isSelected()) {
				hobby+="吃饭,";
			}
			if(jcbb.isSelected()) {
				hobby+="睡觉,";
			}
			if(jcbc.isSelected()) {
				hobby+="游戏";
			}
			//地址
			String address=jcbba.getSelectedItem().toString();
			//备注
			String remark=jta.getText();
			
			//将以上的值封装到一个stu对象中
			Stu s=new Stu();
			s.setSname(sname);
			s.setSex(sex);
			s.setAddress(address);
			s.setPwd(pwd);
			s.setRemark(remark);
			s.setHobby(hobby);
			//调用dao方法进行新增
			StuDao sd=new StuDao();
			int n = sd.addStu(s);
			if(n>0) {
				JOptionPane.showMessageDialog(null, "新增成功！");
				if(MyAdd.this.mc!=null) {
					MyAdd.this.mc.bindData("sname", "");
				}
				MyAdd.this.dispose();
				
			}
			else {

				JOptionPane.showMessageDialog(null, "新增失败！");
			}
		}
	});
	
	
	this.getContentPane().add(jpa);
	this.setVisible(true);
}

}
接下来是updata`
package com.ui;

import java.awt.BorderLayout;
import java.awt.Button;
import java.awt.Color;
import java.awt.Font;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;

import javax.swing.ButtonGroup;
import javax.swing.JButton;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JRadioButton;
import javax.swing.JTextField;

import dao.StudentDao;
import entity.Student;

public class MyUpdate extends JFrame{
//最顶层的面板
JPanel jp = null;
//	上
JPanel jN = null;
JLabel jtitle = null;

//	中
JPanel jC = null;	
JLabel jname = null;
JTextField jtfname = null;

JLabel jsex = null;
JRadioButton jtbB = null;
JRadioButton jtbG = null;
ButtonGroup bg = null;

JLabel jdate = null;
JComboBox<String> jcbY = null;
JComboBox<String> jcbM = null;
JComboBox<String> jcbD = null;

JLabel jhobby = null;
JCheckBox jcbE = null;
JCheckBox jcbS = null;
JCheckBox jcbH = null;

JLabel jaddress = null;
JTextField jtfaddress = null;


	
//	下
JPanel jS = null;
JButton jadd = null;
JButton jdel = null;
JButton jexit = null;



public MyUpdate(int sid) {
	this.setTitle("修改");
	this.setSize(450, 350);
	this.setLocationRelativeTo(null);
	this.setDefaultCloseOperation(this.DISPOSE_ON_CLOSE);
	
	Student stu = new StudentDao().printAll(sid);//单个
//		Student stu = new StudentDao().printAll("", "");
	
	
	//顶层面板
	jp = new JPanel();
	jp.setLayout(new BorderLayout());
	
	
//		上
	jN = new JPanel();
	jtitle = new JLabel("修改学员");
	jtitle.setForeground(Color.red);
	jtitle.setFont(new Font("宋体", Font.BOLD, 40));
	
	jN.add(jtitle);
	
	
//		中
	jC =new JPanel();
	jC.setLayout(null);
	
	jname = new JLabel("姓名");
//		x(50/70) y(0) w宽度(100) h高度（30）	
	jname.setBounds(70, 0, 100, 30);
	
	
	jtfname = new JTextField(stu.getSname(),15);
//		x(右边标签的宽度+10) y(0) w宽度 h高度（30）	
	jtfname.setBounds(100+10, 0, 200, 30);
	
//		JLabel jsex = null;
//		JRadioButton jtbB = null;
//		JRadioButton jtbG = null;
//		ButtonGroup bg = null;
	jsex = new JLabel("性别");
//		x(50/70) y(上边标签的高度+10) w宽度(100) h高度（30）	
	jsex.setBounds(70,40, 100, 30);	
	
	jtbB = new JRadioButton("男");
	jtbB.setSelected(true);		
	jtbB.setBounds(110, 40, 100, 30);		
	jtbG = new JRadioButton("女");
	jtbG.setBounds(110+100, 40, 100, 30);
	bg = new ButtonGroup();
	bg.add(jtbB);
	bg.add(jtbG);
	
	
	if("女".equals(stu.getSex())) {
		jtbG.setSelected(true);
	}
	
	SimpleDateFormat sdf = new SimpleDateFormat("yyyy年MM月dd日");
	Date date = new Date();
	try {
		date = sdf.parse(stu.getBrithday());
	} catch (ParseException e1) {
		// TODO Auto-generated catch block
		e1.printStackTrace();
	}

	jdate = new JLabel("出生日期");
	jdate.setBounds(70, 80, 100, 30);	
	
	jcbY = new JComboBox<String>();
	Date d = new Date();
	for (int i = 1900; i <= d.getYear()+1900; i++) {
		jcbY.addItem(i+"年");
	}
	jcbY.setBounds(130, 80, 70, 30);
	jcbY.setSelectedItem(date.getYear()+1900+"年");
	
	jcbM = new JComboBox<String>();
	for (int i = 1; i <= 12 ; i++) {
		jcbM.addItem(i+"月");
	}
	jcbM.setSelectedItem(date.getMonth()+1+"月");
	jcbM.setBounds(210, 80, 70, 30);
	
	jcbD = new JComboBox<String>();
	Calendar cal = Calendar.getInstance();		
	for (int i = 1; i <= cal.getMaximum(Calendar.DATE); i++) {
		jcbD.addItem(i+"日");
	}
	jcbD.setSelectedItem(date.getDate()+"日");
	jcbD.setBounds(290, 80, 70, 30);
	

	jhobby  = new JLabel("爱好");
	jhobby.setBounds(70, 120, 100, 30);	
	
	jcbE = new JCheckBox("干饭");
	jcbE.setBounds(110, 120, 80, 30);	
	jcbS = new JCheckBox("学习");
	jcbS.setBounds(200, 120, 80, 30);	
	jcbH = new JCheckBox("作业");
	jcbH.setBounds(290, 120, 80, 30);	
	String[] arr = stu.getHobby().split(",");
	for (String s : arr) {
		if("干饭".equals(s)) {
			jcbE.setSelected(true);
		}
		if("学习".equals(s)) {
			jcbS.setSelected(true);
		}
		if("作业".equals(s)) {
			jcbH.setSelected(true);
		}
	}
	

	jaddress = new JLabel("地址");
	jaddress.setBounds(70, 160, 100, 30);	
	jtfaddress = new JTextField(stu.getAddress(),15);
	jtfaddress.setBounds(110, 160, 200, 30);	
	
	jC.add(jname);
	jC.add(jtfname);
	jC.add(jsex);
	jC.add(jtbB);
	jC.add(jtbG);
	jC.add(jdate);
	jC.add(jcbY);
	jC.add(jcbM);
	jC.add(jcbD);
	jC.add(jhobby);
	jC.add(jcbE);
	jC.add(jcbS);
	jC.add(jcbH);
	jC.add(jaddress);
	jC.add(jtfaddress);
//		下
	jS = new JPanel();
	jadd = new JButton("修改");
	jadd.addActionListener(new ActionListener() {
		
		@Override
		public void actionPerformed(ActionEvent e) {
			// TODO Auto-generated method stub
//				1、获取参数
			String sname = jtfname.getText();
			String sex = "男";
			if(jtbG.isSelected()) {					
				sex = "女";
			}
			
			String brithday = jcbY.getSelectedItem().toString()
					+jcbM.getSelectedItem().toString()
					+jcbD.getSelectedItem().toString();
			
			String hobby = "";
			if(jcbE.isSelected()) {
				hobby+="干饭,";
			}
			if(jcbS.isSelected()) {
				hobby+="学习,";
			}
			if(jcbH.isSelected()) {
				hobby+="作业,";
			}
			
			String address = jtfaddress.getText();
			
				
			
			Student stu =new Student(sname, sex, brithday, hobby, address);
			
			//2、调用Dao方法
			int n = new StudentDao().updateById(sid,stu);
			
//				3、提示
			if(n>0) {
				JOptionPane.showMessageDialog(null, "修改成功", "提示", JOptionPane.NO_OPTION);
				
				dispose();
				new MyIndex();
			}else {
				JOptionPane.showMessageDialog(null, "修改失败", "提示", JOptionPane.NO_OPTION);
			}
			
		}
	});
	
	jdel = new JButton("清空");
	jexit = new JButton("退出");
	jS.add(jadd);
	jS.add(jdel);
	jS.add(jexit);	
	
	
	
	
	
	
	jp.add(jN,"North");
	jp.add(jC,"Center");
	jp.add(jS,"South");
	
	
	this.add(jp);
	
	this.setVisible(true);
}

//	public static void main(String[] args) {
//		new Update() ;
//	}

}