import javax.swing.*;
import java.util.*;
import javax.swing.event.*;
import java.sql.*;
import java.util.Vector;
public class AddStudent extends JFrame implements ActionListener
{
JLabel JL=new JLabel("娣誨姞瀛︾敓淇℃伅",JLabel.CENTER);//浣跨敤鏂囨湰鍒涘緩涓涓爣絳懼璞?
JLabel JLNumber=new JLabel("瀛﹀彿錛?quot;);//浣跨敤鏂囨湰鍒涘緩涓涓爣絳懼璞?
JTextField JTNumber=new JTextField();//鍒涘緩涓涓枃鏈瀵硅薄
JLabel JLName=new JLabel("濮撳悕錛?quot;);//浣跨敤鏂囨湰鍒涘緩涓涓爣絳懼璞?
JTextField JTName=new JTextField();//鍒涘緩涓涓枃鏈瀵硅薄
JLabel JLZhuanye=new JLabel("涓撲笟錛?quot;);//浣跨敤鏂囨湰鍒涘緩涓涓爣絳懼璞?
JTextField JTZhuanye=new JTextField();//鍒涘緩涓涓枃鏈瀵硅薄
JLabel JLsex=new JLabel("鎬у埆錛?quot;);//浣跨敤鏂囨湰鍒涘緩涓涓爣絳懼璞?
ButtonGroup BG=new ButtonGroup();//鍒涘緩涓涓狟uttonGroup緇勪歡瀵硅薄
JRadioButton JRB1=new JRadioButton("鐢?quot;);//鍒涘緩涓涓崟閫夋寜閽璞?
JRadioButton JRB2=new JRadioButton("濂?quot;);
JLabel JL1=new JLabel("騫寸駭:錛?quot;);//浣跨敤鏂囨湰鍒涘緩涓涓爣絳懼璞?
JTextField JT1=new JTextField();//鍒涘緩涓涓枃鏈瀵硅薄
JLabel JL2=new JLabel("鍑虹敓錛?quot;);
JTextField JT2=new JTextField();
JButton JBAdd=new JButton("褰曞叆");//鍒涘緩鎸夐挳瀵硅薄
JButton JBNext=new JButton("閲嶇疆");
String sql="";//瀹氫箟涓涓瓧絎︿覆
public AddStudent()//鍒涘緩AddStudent鏋勯犳柟娉?
{
this.setTitle("娣誨姞瀛︾敓淇℃伅");//璁劇疆紿楀彛鏍囬
this.setLayout(null);//璁劇疆紿楀彛甯冨眬綆＄悊鍣?
JL.setForeground(Color.red);//璁劇疆鏍囩鐨勫墠鏅壊
JL.setFont(new java.awt.Font("瀹嬩綋",Font.PLAIN,19));//璁劇疆鏍囩鐨勫瓧浣?
JL.setBounds(200,30,200,40);//璁劇疆鏍囩鐨勫垵濮嬩綅緗?
this.add(JL);//灝嗘爣絳炬坊鍔犲埌瀹瑰櫒
JLNumber.setBounds(195,80,100,20);//璁劇疆瀛﹀彿鏍囩鐨勫垵濮嬩綅緗?
this.add(JLNumber);//灝嗗鍙鋒爣絳炬坊鍔犲埌瀹瑰櫒
JTNumber.setBounds(240,80,170,20);//璁劇疆鏂囨湰妗嗙殑鍒濆浣嶇疆
this.add(JTNumber);//灝嗘枃鏈娣誨姞鍒板鍣?
JLName.setBounds(195,100,60,20);//璁劇疆濮撳悕鏍囩鐨勫垵濮嬩綅緗?
this.add(JLName);//灝嗗鍚嶆爣絳炬坊鍔犲埌瀹瑰櫒
JTName.setBounds(240,100,170,20);//璁劇疆鏂囨湰妗嗙殑鍒濆浣嶇疆
this.add(JTName);//灝嗘枃鏈娣誨姞鍒板鍣?
JLsex.setBounds(220,120,100,20);//璁劇疆鎬у埆鏍囩鐨勫垵濮嬩綅緗?
this.add(JLsex);//灝嗘у埆鏍囩娣誨姞鍒板鍣?
JRB1.setBounds(270,120,40,20);//璁劇疆鍗曢夋寜閽殑鍒濆浣嶇疆
JRB2.setBounds(320,120,40,20);
this.add(JRB1);//娣誨姞鍗曢夋寜閽粍浠?
this.add(JRB2);
BG.add(JRB1);//灝嗗崟閫夋寜閽坊鍔犲埌Button Group緇勫緩
BG.add(JRB2);
JLZhuanye.setBounds(195,140,60,20);//璁劇疆涓撲笟鏍囩鐨勫垵濮嬩綅緗?
this.add(JLZhuanye);//灝嗕笓涓氭爣絳炬坊鍔犲埌瀹瑰櫒
JTZhuanye.setBounds(240,140,170,20);//璁劇疆鏂囨湰妗嗙殑鍒濆浣嶇疆
this.add(JTZhuanye);//灝嗘枃鏈娣誨姞鍒板鍣?
JL1.setBounds(195,160,60,20);//璁劇疆騫寸駭鏍囩鐨勫垵濮嬩綅緗?
this.add(JL1);//灝嗗勾綰ф爣絳炬坊鍔犲埌瀹瑰櫒
JT1.setBounds(240,160,170,20);//璁劇疆鏂囨湰妗嗙殑鍒濆浣嶇疆
this.add(JT1);//灝嗘枃鏈娣誨姞鍒板鍣?
JL2.setBounds(195,180,60,20);//璁劇疆鍑虹敓鏍囩鐨勫垵濮嬩綅緗?
this.add(JL2);
JT2.setBounds(240,180,170,20);
this.add(JT2);
JBAdd.setBounds(210,260,90,25);//璁劇疆娣誨姞鎸夐挳鐨勫垵濮嬩綅緗?
this.add(JBAdd);//灝嗘坊鍔犳寜閽坊鍔犲埌瀹瑰櫒
JBAdd.addActionListener(this);//緇欐寜閽坊鍔犵洃鍚櫒
JBNext.setBounds(310,260,90,25);//璁劇疆閲嶇疆鎸夐挳鐨勫垵濮嬩綅緗?
this.add(JBNext);//灝嗛噸緗寜閽坊鍔犲埌瀹瑰櫒
JBNext.addActionListener(this);//緇欐寜閽坊鍔犵洃鍚櫒
this.setBounds(10,10,600,350);//璁劇疆紿楀彛灝哄澶у皬
this.setVisible(true);//璁劇疆紿楀彛鍙鎬?
addWindowListener(new WindowAdapter()
{
public void windowClosing(WindowEvent e)
{
System.exit(0);
}
});
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==JBAdd)//澶勭悊"娣誨姞"浜嬩歡
{
String snumber=JTNumber.getText();//灝嗘枃鏈涓寘鍚殑鏂囨湰浼犵粰瀛楃涓瞫number
String sname=JTName.getText();//灝嗘枃鏈涓寘鍚殑鏂囨湰浼犵粰瀛楃涓瞫name
String szhuanye=JTZhuanye.getText();//灝嗘枃鏈涓寘鍚殑鏂囨湰浼犵粰瀛楃涓瞫class
String ssex="濂?quot;;//榪斿洖鍗曢夋寜閽殑鍊?
if(JRB1.isSelected())
ssex="鐢?quot;;
String nianji=JT1.getText();//灝嗘枃鏈涓寘鍚殑鏂囨湰浼犵粰瀛楃涓瞫collect
String chusheng=JT2.getText();
//String sql="select * from student where Id='"+snumber+"'";//媯(gè)绱㈠嚭Id絳変簬snumber鐨勫鐢熺殑鎵鏈変俊鎭?
try //寮傚父澶勭悊
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//鍔犺澆椹卞姩紼嬪簭
Connection cot=DriverManager.getConnection("jdbc:odbc:student1","","");
sql="insert into student values(?,?,?,?,?,?,?,?,?,?)";//鎵撳紑鏁版嵁搴撹繛鎺ワ紝student1涓烘暟鎹簮鍚嶇О
PreparedStatement pstm=cot.prepareStatement(sql);//鎻愪氦鏌ヨ
// if(rs.next())//鍒ゆ柇緇撴灉鏄惁瀛樺湪
//JOptionPane.showMessageDialog(null,"璇ュ彿宸茬粡瀛樺湪!");//閫氳繃showMessageDialog()鏂規(guī)硶鎵撳嵃淇℃伅
//else
//{
//鎻掑叆涓緇勬暟鎹?
pstm.setString(1,snumber);
pstm.setString(2,sname);
pstm.setString(3,szhuanye);
pstm.setString(4,ssex);
pstm.setString(5,nianji);
pstm.setString(6,chusheng);
int i=pstm.executeUpdate(); //瀵規(guī)暟鎹簱榪涜鏇存柊
if(i>0)
JOptionPane.showMessageDialog(null,"娣誨姞鎴愬姛!");
else
JOptionPane.showMessageDialog(null,"鍒犻櫎澶辮觸!");
}
catch(Exception ee)
{
}
}
if(e.getSource()==JBNext)//澶勭悊"閲嶇疆"浜嬩歡
{
JTNumber.setText(null);//璁劇疆鏂囨湰鐨則ext鍊間負(fù)null
JTName.setText(null);//璁劇疆鏂囨湰鐨則ext鍊間負(fù)null
JTZhuanye.setText(null);//璁劇疆鏂囨湰鐨則ext鍊間負(fù)null
JT1.setText(null);//璁劇疆鏂囨湰鐨則ext鍊間負(fù)null
JT2.setText(null);
}
}
public static void main(String args[])
{
new AddStudent();
}
}
]]>
]]>
]]>
]]>
]]>
mysql> alter table apr_05 modify Date character set utf8;
ERROR 1064 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'set utf8' at line 1
鎴戦渶瑕佺敤utf8鏍煎紡鐨勶紝搴旇娌℃湁鍐欓敊鍚р︹︽眰鏁欙紝璋㈣阿錛?br>
]]>
]]>
]]>
zhijie_zhang 2010-02-08 23:25 鍙戣〃璇勮
]]>zhijie_zhang 2010-01-10 01:11 鍙戣〃璇勮
]]>]]>