inputtest.java~22~

Tt s a good book ,if you want to learn java good

package sos;

import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;

public class InputTest extends JFrame implements ActionListener {
    static boolean hasInput = false;
    static String xuehao = "20053001041", xingming = "舍甫琴柯", shenfenzhenghao =
            "370882198703051671", nianling = "20", minzu = "汉", zhuanye =
                    "软件工程", yuanxiao = "山东大学齐鲁软件学院", nianji = "2005", banji =
                            "软件一班", jiudu = "本科一年级",
    xingbie = "男", beizhu = "无";
    public static void main(String[] args) {
        try {
            Statement stmt;
            PreparedStatement pstmt;
            ResultSet rs;
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:db_STU", "",
                    "");
            stmt = con.createStatement();
            rs = stmt.executeQuery("insert into Basic_Info(学号,姓名,身份证号码,性别,年龄,民族,所学专业,所在院校,年级,班级,就读,备注) values('xuehao','xingming','shenfenzhenghao','xingbie','nianling','minzu','zhuanye','yuanxiao','nianji','banji','jiudu','beizhu')");
            rs = stmt.executeQuery(
                    "SELECT 学号,姓名,身份证号码,性别,年龄,民族,所学专业,所在院校,年级,班级,就读,备注 from Basic_Info");
            System.out.println("结果为：");
            while (rs.next()) {
                String strNumber = rs.getString("学号");
                String strName = rs.getString("姓名");
                String strID = rs.getString("身份证号码");
                String strSex = rs.getString("性别");
                String strAge = rs.getString("年龄");
                String strNation = rs.getString("民族");
                String strMajor = rs.getString("所学专业");
                String strCollege = rs.getString("所在院校");
                String strGrade = rs.getString("年级");
                String strClass = rs.getString("班级");
                String strStatus = rs.getString("就读");
                String strOther = rs.getString("备注");
                System.out.println("学号:　" + strNumber + "  \t" + "姓名:　" +
                                   strName +
                                   "  \t" +
                                   "身份证号码: " + strID + "  \t" + "性别: " + strSex +
                                   "  \t" + "年龄: " +
                                   strAge + "  \t" + "民族: " + strNation +
                                   "  \t" +
                                   "所学专业: " +
                                   strMajor + "  \t" + "所在院校: " + strCollege +
                                   "  \t" + "年级: " +
                                   strGrade + "  \t" + "班级: " + strClass +
                                   "  \t" +
                                   "就读: " +
                                   strStatus + "  \t" + "备注: " + strOther);
            }
            //    pstmt = con.prepareStatement(
            //         "UPDATE Basic_Info SET 年龄=? WHERE 年龄=?");
            //    pstmt.setString(1, "20");
            //  pstmt.setString(2, "19");
            //   pstmt.executeUpdate();
            con.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public void query() {}

    public void actionPerformed(ActionEvent e) {
    }

}