xfbz.java~3~

来自「培训中心办公自动化系统之财务管理模块 包括缴纳报名费、学费」· JAVA~3~ 代码 · 共 64 行

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


public class xfbz {
    private PreparedStatement pstmt;

    private void initializeDB(){
        String sql_driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
        String sql_url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pxzx";
        //语句一，其中manage是要访问的数据库名
        String user = "sa"; //你要访问的数据库用户名
        String pwd = "1"; //访问数据库的密 码

        try {
            Class.forName(sql_driver);
            System.out.println("driver loaded");
            Connection connection = DriverManager.getConnection(sql_url, user, pwd);
            System.out.println("database connected");

            String insertString = "insert into 学费收入表(T_id,T_data,St_id,St_name,C_id,Tu_mon,"+
                                  "Tu_check,Tu_check_id) values(?,?,?,?,?,?,?,?)";
            pstmt = connection.prepareStatement(insertString);
        }catch (Exception ex) {
            ex.printStackTrace();
        }
    }
    public xfbz() {
    }

    private void insertData(){
        String T_id="12";
        String T_data="2008-03-25" ;
        int St_id=1;
        String St_name="lu";
        String C_id="25";
        float Tu_mon=100;
        String Tu_check="Y";
        String Tu_check_id="451";

        try{
            pstmt.setString(1,T_id);
            pstmt.setString(2,T_data);
            pstmt.setInt(3,St_id);
            pstmt.setString(4,St_name);
            pstmt.setString(5,C_id);
            pstmt.setFloat(6,Tu_mon);
            pstmt.setString(7,Tu_check);
            pstmt.setString(8,Tu_check_id);

        }catch(SQLException ex){
            ex.printStackTrace();
        }
    }

    public static void main(String [] args){
        xfbz a=new xfbz();
        a.initializeDB();
        a.insertData();
    }
}