-
大小: 280KB文件類型: .rar金幣: 2下載: 0 次發(fā)布日期: 2021-05-10
- 語(yǔ)言: Java
- 標(biāo)簽:
資源簡(jiǎn)介
用Java和SQL-Server做的學(xué)生管理系統(tǒng)

代碼片段和文件信息
//3.添加學(xué)生面板類
//導(dǎo)入系統(tǒng)的類包
import?java.awt.*;
import?java.sql.*;
import?javax.swing.*;
import?java.awt.event.*;
//創(chuàng)建“添加學(xué)生面板”類
public?class?AddStudentPanel?extends?JPanel?implements?ActionListener
{
//聲明連接數(shù)據(jù)庫(kù)對(duì)象
Connection?con;
//聲明SQL語(yǔ)句對(duì)象
Statement?st;
//創(chuàng)建組件對(duì)象:標(biāo)簽、文本行、單選
JLabel?jLabel1=new?JLabel(“學(xué)號(hào)“);
JLabel?jLabel2=new?JLabel(“姓名“);
JLabel?jLabel3=new?JLabel(“性別“);
JLabel?jLabel4=new?JLabel(“出生日期“);
JLabel?jLabel5=new?JLabel(“籍貫“);
JLabel?jLabel6=new?JLabel(“注意:出生日期格式為YYYY-MM-DD“);
JTextField?jTextField1=new?JTextField();
JTextField?jTextField2=new?JTextField();
JTextField?jTextField3=new?JTextField();
JTextField?jTextField4=new?JTextField();
JRadioButton?jRadioButton1=new?JRadioButton(“男“);
JRadioButton?jRadioButton2=new?JRadioButton(“女“);
ButtonGroup?buttonGroup1=new?ButtonGroup();
JButton?jButton1=new?JButton(“存入數(shù)據(jù)庫(kù)“);
//構(gòu)造方法
public?AddStudentPanel()
{
try{
//調(diào)用初始化方法
jbInit();
}
catch(Exception?exception){
exception.printStackTrace();
}
}
//界面初始化方法
private?void?jbInit()?throws?Exception
{
//連接數(shù)據(jù)庫(kù)
con=DBConnect.getConn();
st=con.createStatement();
//框架的布局
this.setLayout(null);
//設(shè)置各組件的大小
jLabel1.setBounds(new?Rectangle(21176424));
jLabel2.setBounds(new?Rectangle(21515322));
jLabel3.setBounds(new?Rectangle(21866127));
jLabel4.setBounds(new?Rectangle(211225925));
jLabel5.setBounds(new?Rectangle(211885424));
jLabel6.setBounds(new?Rectangle(10215321927));
jTextField1.setBounds(new?Rectangle(1021020030));
jTextField2.setBounds(new?Rectangle(1024920030));
jTextField3.setBounds(new?Rectangle(10211720033));
jTextField4.setBounds(new?Rectangle(10218320029));
jRadioButton1.setBounds(new?Rectangle(102836530));
jRadioButton2.setBounds(new?Rectangle(190858530));
jButton1.setBounds(new?Rectangle(10321718030));
//設(shè)置單選按鈕被選中
jRadioButton1.setSelected(true);
//添加按鈕動(dòng)作事件
jButton1.addActionListener(this);
//添加組件到面板
this.add(jTextField1);
this.add(jLabel1);
this.add(jLabel2);
this.add(jTextField2);
this.add(jRadioButton1);
this.add(jRadioButton2);
this.add(jLabel3);
this.add(jLabel4);
this.add(jTextField3);
this.add(jLabel6);
this.add(jTextField4);
this.add(jLabel5);
this.add(jButton1);
buttonGroup1.add(jRadioButton1);
buttonGroup1.add(jRadioButton2);
}
//點(diǎn)擊按鈕事件
public?void?actionPerformed(ActionEvent?e)
{
//獲取用戶輸入的信息
String?xuehao=jTextField1.getText();
String?xingming=jTextField2.getText();
String?xingbie=““;
if(jRadioButton1.isSelected())
xingbie+=“男“;
if(jRadioButton2.isSelected())
xingbie+=“女“;
String?dateString=jTextField3.getText();
String?jiguan=jTextField4.getText();
try{
//設(shè)置日期格式
st.execute(“set?dateformat?ymd“);
//利用st對(duì)象執(zhí)行SQL語(yǔ)句,進(jìn)行插入操作
st.executeUpdate(“insert?into?StudentInfo?values(‘“+xuehao+“‘‘“+xingming+“‘‘“+xingbie+“‘‘“+dateString+“‘‘“+jiguan+“‘‘“+xuehao
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件???????4000??2010-12-06?18:40??學(xué)生管理系統(tǒng)\AddStudentPanel.class
?????文件???????3659??2010-12-06?18:23??學(xué)生管理系統(tǒng)\AddStudentPanel.java
?????文件????????619??2010-12-06?18:40??學(xué)生管理系統(tǒng)\DBConnect.class
?????文件????????430??2010-12-06?16:38??學(xué)生管理系統(tǒng)\DBConnect.java
?????文件???????2538??2010-12-06?18:40??學(xué)生管理系統(tǒng)\DeleteStudentPanel.class
?????文件???????1862??2010-11-10?19:41??學(xué)生管理系統(tǒng)\DeleteStudentPanel.java
?????文件???????3188??2010-12-06?18:40??學(xué)生管理系統(tǒng)\InquireOnNamePanel.class
?????文件???????2228??2010-12-06?18:38??學(xué)生管理系統(tǒng)\InquireOnNamePanel.java
?????文件???????2995??2010-12-06?18:40??學(xué)生管理系統(tǒng)\InquireOnXHPanel.class
?????文件???????2260??2010-12-06?18:39??學(xué)生管理系統(tǒng)\InquireOnXHPanel.java
?????文件????????714??2010-12-06?18:40??學(xué)生管理系統(tǒng)\Main.class
?????文件????????734??2010-12-06?16:43??學(xué)生管理系統(tǒng)\Main.java
?????文件???????3413??2010-12-06?18:40??學(xué)生管理系統(tǒng)\Mainfr
?????文件???????3761??2010-12-06?16:45??學(xué)生管理系統(tǒng)\Mainfr
?????文件????1048576??2010-12-06?19:14??學(xué)生管理系統(tǒng)\StudentManager_Data.MDF
?????文件????1048576??2010-12-06?19:14??學(xué)生管理系統(tǒng)\StudentManager_Log.LDF
?????文件?????267776??2010-12-06?19:13??學(xué)生管理系統(tǒng)\用Java和SQL-Server做的學(xué)生管理系統(tǒng).doc
????...D..R?????????0??2010-12-06?19:14??學(xué)生管理系統(tǒng)
-----------?---------??----------?-----??----
??????????????2397329????????????????????18
評(píng)論
共有 條評(píng)論