نمایش نتایج 1 تا 2 از 2

نام تاپیک: نوشتن برنامه در نت بینز برای یک db در sql server لطفا کمک کنین خیلی مهمه !!!!

  1. #1

    Unhappy نوشتن برنامه در نت بینز برای یک db در sql server لطفا کمک کنین خیلی مهمه !!!!

    سلام یه پروژه دانشگاه باید انجام بدم که باید برای پایگاه داده در sql server باید aplication درست کنیم که اعمال حذف ، درج و آپدیت و ... را انجام بده ...تا یه جایی برنامه رو نوشتم و متوجه error های مختلف شدم و رفع کردم ... ولی بازم برنامه به sql کانکت نمیشه و output متن زیر رو نشون میده ...
    init:
    deps-jar:
    compile-single:
    run-single:
    Exception: com.sqlserver.jdbc.Driver

    کدی که نوشتم اینه !



    package library;

    import java.security.SecureRandom;
    import java.util.*;
    import javax.swing.*;
    import java.sql.*;
    import java.util.logging.*;


    /**
    *
    * @author KENT WAYNE
    */
    public class LibraryApp extends javax.swing.JFrame {

    private final static String url="jdbc:sqlserver://localhost;databaseName=Library;instanceName=instan ce1;integratedSecurity=true;";
    static Connection conn = null;
    static Statement stmt = null;
    static ResultSet result = null;
    /** Creates new form LibraryApp */
    public LibraryApp(){
    initComponents();
    }

    /** This method is called from within the constructor to
    * initialize the form.
    * WARNING: Do NOT modify this code. The content of this method is
    * always regenerated by the Form Editor.
    */
    // <editor-fold defaultstate="collapsed" desc=" Generated Code ">
    private void initComponents() {
    jPopupMenu1 = new javax.swing.JPopupMenu();
    sabt = new javax.swing.JFrame();
    jLabel1 = new javax.swing.JLabel();
    jLabel2 = new javax.swing.JLabel();
    jLabel3 = new javax.swing.JLabel();
    jLabel4 = new javax.swing.JLabel();
    jLabel5 = new javax.swing.JLabel();
    jTextField1 = new javax.swing.JTextField();
    jTextField2 = new javax.swing.JTextField();
    jTextField3 = new javax.swing.JTextField();
    jTextField4 = new javax.swing.JTextField();
    jLabel6 = new javax.swing.JLabel();
    jTextField5 = new javax.swing.JTextField();
    jLabel7 = new javax.swing.JLabel();
    jTextField6 = new javax.swing.JTextField();
    jButton1 = new javax.swing.JButton();
    jPasswordField2 = new javax.swing.JPasswordField();
    jLabel8 = new javax.swing.JLabel();
    look = new javax.swing.JFrame();
    jLabel9 = new javax.swing.JLabel();
    jLabel10 = new javax.swing.JLabel();
    jButton2 = new javax.swing.JButton();
    jTextField7 = new javax.swing.JTextField();
    jButton3 = new javax.swing.JButton();
    jScrollPane1 = new javax.swing.JScrollPane();
    jList1 = new javax.swing.JList();
    modir = new javax.swing.JFrame();
    jLabel11 = new javax.swing.JLabel();
    jPanel1 = new javax.swing.JPanel();
    jComboBox2 = new javax.swing.JComboBox();
    jLabel12 = new javax.swing.JLabel();
    jTextField8 = new javax.swing.JTextField();
    jLabel13 = new javax.swing.JLabel();
    jPasswordField1 = new javax.swing.JPasswordField();
    jLabel14 = new javax.swing.JLabel();
    jButton4 = new javax.swing.JButton();
    jMenuBar1 = new javax.swing.JMenuBar();
    jMenu1 = new javax.swing.JMenu();
    jMenuItem1 = new javax.swing.JMenuItem();
    jMenuItem2 = new javax.swing.JMenuItem();
    jMenuItem3 = new javax.swing.JMenuItem();
    jMenuItem4 = new javax.swing.JMenuItem();

    sabt.setTitle("registration form");
    jLabel1.setText("\u0628\u0631\u0627\u06cc \u0639\u0636\u0648\u06cc\u062a \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0632\u06cc\u0631 \u0631\u0627 \u062a\u06a9\u0645\u06cc\u0644 \u0646\u0645\u0627\u06cc\u06cc\u062f");

    jLabel2.setText("\u0646\u0627\u0645");

    jLabel3.setText("\u0646\u0627\u0645 \u062e\u0627\u0646\u0648\u0627\u062f\u06af\u06cc") ;

    jLabel4.setText("\u0646\u0627\u0645 \u067e\u062f\u0631");

    jLabel5.setText("\u06a9\u062f \u0645\u0644\u06cc");

    jLabel6.setText("\u062a\u0627\u0631\u06cc\u062e \u062a\u06a9\u0645\u06cc\u0644 \u0641\u0631\u0645");

    jLabel7.setText("\u062a\u0627\u0631\u06cc\u062e \u062a\u0648\u0644\u062f");

    jButton1.setText("\u062a\u0627\u06cc\u06cc\u062f") ;
    jButton1.addActionListener(new java.awt.event.ActionListener() {
    public void actionPerformed(java.awt.event.ActionEvent evt) {
    jButton1ActionPerformed(evt);
    }
    });

    jLabel8.setText("\u06af\u0630\u0631 \u0648\u0627\u0698\u0647");

    javax.swing.GroupLayout sabtLayout = new javax.swing.GroupLayout(sabt.getContentPane());
    sabt.getContentPane().setLayout(sabtLayout);
    sabtLayout.setHorizontalGroup(
    sabtLayout.createParallelGroup(javax.swing.GroupLa yout.Alignment.LEADING)
    .addGroup(sabtLayout.createSequentialGroup()
    .addGap(143, 143, 143)
    .addComponent(jLabel1)
    .addContainerGap(172, Short.MAX_VALUE))
    .addGroup(javax.swing.GroupLayout.Alignment.TRAILI NG, sabtLayout.createSequentialGroup()
    .addContainerGap(116, Short.MAX_VALUE)
    .addGroup(sabtLayout.createParallelGroup(javax.swi ng.GroupLayout.Alignment.TRAILING, false)
    .addComponent(jPasswordField2, 0, 0, Short.MAX_VALUE)
    .addComponent(jTextField6)
    .addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, 66, javax.swing.GroupLayout.PREFERRED_SIZE))
    .addGap(39, 39, 39)
    .addGroup(sabtLayout.createParallelGroup(javax.swi ng.GroupLayout.Alignment.LEADING)
    .addComponent(jLabel8)
    .addComponent(jLabel6)
    .addComponent(jLabel7))
    .addGap(38, 38, 38)
    .addGroup(sabtLayout.createParallelGroup(javax.swi ng.GroupLayout.Alignment.TRAILING, false)
    .addComponent(jTextField4)
    .addGroup(sabtLayout.createSequentialGroup()
    .addComponent(jTextField1, javax.swing.GroupLayout.DEFAULT_SIZE, 59, Short.MAX_VALUE)
    .addPreferredGap(javax.swing.LayoutStyle.Component Placement.RELATED))
    .addComponent(jTextField2)
    .addComponent(jTextField3))
    .addGap(40, 40, 40)
    .addGroup(sabtLayout.createParallelGroup(javax.swi ng.GroupLayout.Alignment.TRAILING)
    .addGroup(sabtLayout.createSequentialGroup()
    .addGroup(sabtLayout.createParallelGroup(javax.swi ng.GroupLayout.Alignment.LEADING)
    .addComponent(jLabel5)
    .addComponent(jLabel4)
    .addComponent(jLabel2))
    .addGap(23, 23, 23))
    .addGroup(sabtLayout.createSequentialGroup()
    .addComponent(jLabel3)
    .addContainerGap())))
    .addGroup(javax.swing.GroupLayout.Alignment.TRAILI NG, sabtLayout.createSequentialGroup()
    .addContainerGap(239, Short.MAX_VALUE)
    .addComponent(jButton1)
    .addGap(208, 208, 208))
    );
    sabtLayout.setVerticalGroup(
    sabtLayout.createParallelGroup(javax.swing.GroupLa yout.Alignment.LEADING)
    .addGroup(sabtLayout.createSequentialGroup()
    .addContainerGap()
    .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 36, javax.swing.GroupLayout.PREFERRED_SIZE)
    .addGap(37, 37, 37)
    .addGroup(sabtLayout.createParallelGroup(javax.swi ng.GroupLayout.Alignment.BASELINE)
    .addComponent(jLabel2)
    .addComponent(jLabel6)
    .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    .addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
    .addGap(28, 28, 28)
    .addGroup(sabtLayout.createParallelGroup(javax.swi ng.GroupLayout.Alignment.LEADING)
    .addGroup(sabtLayout.createSequentialGroup()
    .addGap(48, 48, 48)
    .addGroup(sabtLayout.createParallelGroup(javax.swi ng.GroupLayout.Alignment.BASELINE)
    .addComponent(jLabel4)
    .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    .addComponent(jPasswordField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    .addComponent(jLabel8)))
    .addGroup(sabtLayout.createParallelGroup(javax.swi ng.GroupLayout.Alignment.BASELINE)
    .addComponent(jLabel3)
    .addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    .addComponent(jLabel7)
    .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
    .addGap(27, 27, 27)
    .addGroup(sabtLayout.createParallelGroup(javax.swi ng.GroupLayout.Alignment.TRAILING)
    .addComponent(jLabel5)
    .addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
    .addGap(25, 25, 25)
    .addComponent(jButton1)
    .addContainerGap(106, Short.MAX_VALUE))
    );
    look.setTitle("search");
    jLabel9.setText("\u062c\u0633\u062a\u062c\u0648 \u0628\u0631 \u0627\u0633\u0627\u0633");

    jLabel10.setText("\u0647\u0646\u0648\u0632 \u0645\u0648\u0631\u062f\u06cc \u0627\u0646\u062a\u062e\u0627\u0628 \u0646\u0634\u062f\u0647");

    jButton2.setText("change metod");
    jButton2.addActionListener(new java.awt.event.ActionListener() {
    public void actionPerformed(java.awt.event.ActionEvent evt) {
    jButton2ActionPerformed(evt);
    }
    });

    jTextField7.setText("jTextField7");

    jButton3.setText("\u062c\u0633\u062a\u062c\u0648") ;

    jList1.setModel(new javax.swing.AbstractListModel() {
    String[] strings = { "Item 1", "Item 2", "Item 3", "Item 4", "Item 5" };
    public int getSize() { return strings.length; }
    public Object getElementAt(int i) { return strings[i]; }
    });
    jScrollPane1.setViewportView(jList1);

    javax.swing.GroupLayout lookLayout = new javax.swing.GroupLayout(look.getContentPane());
    look.getContentPane().setLayout(lookLayout);
    lookLayout.setHorizontalGroup(
    lookLayout.createParallelGroup(javax.swing.GroupLa yout.Alignment.LEADING)
    .addGroup(lookLayout.createSequentialGroup()
    .addContainerGap(12, Short.MAX_VALUE)
    .addGroup(lookLayout.createParallelGroup(javax.swi ng.GroupLayout.Alignment.LEADING)
    .addGroup(javax.swing.GroupLayout.Alignment.TRAILI NG, lookLayout.createSequentialGroup()
    .addComponent(jButton2)
    .addGap(35, 35, 35)
    .addComponent(jLabel10)
    .addGap(19, 19, 19)
    .addComponent(jLabel9)
    .addGap(39, 39, 39))
    .addGroup(javax.swing.GroupLayout.Alignment.TRAILI NG, lookLayout.createSequentialGroup()
    .addComponent(jButton3)
    .addGap(17, 17, 17)
    .addComponent(jTextField7, javax.swing.GroupLayout.PREFERRED_SIZE, 97, javax.swing.GroupLayout.PREFERRED_SIZE)
    .addGap(116, 116, 116))))
    .addGroup(lookLayout.createSequentialGroup()
    .addGap(66, 66, 66)
    .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 239, javax.swing.GroupLayout.PREFERRED_SIZE)
    .addContainerGap(95, Short.MAX_VALUE))
    );
    lookLayout.setVerticalGroup(
    lookLayout.createParallelGroup(javax.swing.GroupLa yout.Alignment.LEADING)
    .addGroup(lookLayout.createSequentialGroup()
    .addGap(19, 19, 19)
    .addGroup(lookLayout.createParallelGroup(javax.swi ng.GroupLayout.Alignment.BASELINE)
    .addComponent(jLabel9)
    .addComponent(jLabel10)
    .addComponent(jButton2))
    .addGap(58, 58, 58)
    .addGroup(lookLayout.createParallelGroup(javax.swi ng.GroupLayout.Alignment.BASELINE)
    .addComponent(jButton3)
    .addComponent(jTextField7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
    .addGap(21, 21, 21)
    .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    .addContainerGap(26, Short.MAX_VALUE))
    );
    javax.swing.GroupLayout modirLayout = new javax.swing.GroupLayout(modir.getContentPane());
    modir.getContentPane().setLayout(modirLayout);
    modirLayout.setHorizontalGroup(
    modirLayout.createParallelGroup(javax.swing.GroupL ayout.Alignment.LEADING)
    .addGap(0, 400, Short.MAX_VALUE)
    );
    modirLayout.setVerticalGroup(
    modirLayout.createParallelGroup(javax.swing.GroupL ayout.Alignment.LEADING)
    .addGap(0, 300, Short.MAX_VALUE)
    );

    jLabel11.setText("\u0644\u0637\u0641\u0627 \u0628\u0631\u0627\u06cc \u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645 \u0646\u0648\u0639 \u06a9\u0627\u0631\u0628\u0631\u06cc \u062e\u0648\u062f \u0631\u0627 \u0645\u0634\u062e\u0635 \u06a9\u0646\u06cc\u062f \u06cc\u0627 \u0628\u0631\u0627\u06cc \u062b\u0628\u062a \u0646\u0627\u0645 \u0627\u0632 \u0645\u0646\u0648\u06cc \u06a9\u0627\u0631\u0628\u0631\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f");

    jPanel1.setBorder(javax.swing.BorderFactory.create EtchedBorder());
    jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "\u0645\u062f\u06cc\u0631\u06cc\u062a", "\u0627\u0639\u0636\u0627" }));

    jLabel12.setText("\u0646\u0648\u0639 \u06a9\u0627\u0631\u0628\u0631\u06cc");

    jTextField8.setText("jTextField8");

    jLabel13.setText("\u0646\u0627\u0645 \u06a9\u0627\u0631\u0628\u0631\u06cc");

    jPasswordField1.setText("jPasswordField1");

    jLabel14.setText("\u06af\u0630\u0631 \u0648\u0627\u0698\u0647");

    jButton4.setText("\u0648\u0631\u0648\u062f");
    jButton4.addActionListener(new java.awt.event.ActionListener() {
    public void actionPerformed(java.awt.event.ActionEvent evt) {
    jButton4ActionPerformed(evt);
    }
    });

    javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
    jPanel1.setLayout(jPanel1Layout);
    jPanel1Layout.setHorizontalGroup(
    jPanel1Layout.createParallelGroup(javax.swing.Grou pLayout.Alignment.LEADING)
    .addGroup(javax.swing.GroupLayout.Alignment.TRAILI NG, jPanel1Layout.createSequentialGroup()
    .addGroup(jPanel1Layout.createParallelGroup(javax. swing.GroupLayout.Alignment.TRAILING)
    .addGroup(jPanel1Layout.createSequentialGroup()
    .addGroup(jPanel1Layout.createParallelGroup(javax. swing.GroupLayout.Alignment.LEADING)
    .addGroup(jPanel1Layout.createSequentialGroup()
    .addGap(64, 64, 64)
    .addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
    .addGroup(jPanel1Layout.createSequentialGroup()
    .addGap(41, 41, 41)
    .addGroup(jPanel1Layout.createParallelGroup(javax. swing.GroupLayout.Alignment.LEADING)
    .addComponent(jPasswordField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    .addComponent(jTextField8, javax.swing.GroupLayout.PREFERRED_SIZE, 110, javax.swing.GroupLayout.PREFERRED_SIZE))))
    .addPreferredGap(javax.swing.LayoutStyle.Component Placement.RELATED, 44, Short.MAX_VALUE)
    .addGroup(jPanel1Layout.createParallelGroup(javax. swing.GroupLayout.Alignment.LEADING)
    .addComponent(jLabel14)
    .addComponent(jLabel13)))
    .addComponent(jLabel12))
    .addGap(31, 31, 31))
    .addGroup(jPanel1Layout.createSequentialGroup()
    .addGap(98, 98, 98)
    .addComponent(jButton4)
    .addContainerGap(124, Short.MAX_VALUE))
    );
    jPanel1Layout.setVerticalGroup(
    jPanel1Layout.createParallelGroup(javax.swing.Grou pLayout.Alignment.LEADING)
    .addGroup(jPanel1Layout.createSequentialGroup()
    .addContainerGap()
    .addGroup(jPanel1Layout.createParallelGroup(javax. swing.GroupLayout.Alignment.BASELINE)
    .addComponent(jLabel12)
    .addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
    .addGap(21, 21, 21)
    .addGroup(jPanel1Layout.createParallelGroup(javax. swing.GroupLayout.Alignment.BASELINE)
    .addComponent(jLabel13)
    .addComponent(jTextField8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
    .addGap(32, 32, 32)
    .addGroup(jPanel1Layout.createParallelGroup(javax. swing.GroupLayout.Alignment.BASELINE)
    .addComponent(jPasswordField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    .addComponent(jLabel14))
    .addGap(22, 22, 22)
    .addComponent(jButton4)
    .addContainerGap(29, Short.MAX_VALUE))
    );

    jMenu1.setText("\u0645\u0646\u0648 \u06a9\u0627\u0631\u0628\u0631\u06cc");
    jMenu1.addActionListener(new java.awt.event.ActionListener() {
    public void actionPerformed(java.awt.event.ActionEvent evt) {
    jMenu1ActionPerformed(evt);
    }
    });

    jMenuItem1.setLabel("\u062b\u0628\u062a \u0646\u0627\u0645");
    jMenuItem1.addMouseListener(new java.awt.event.MouseAdapter() {
    public void mouseClicked(java.awt.event.MouseEvent evt) {
    jMenuItem1MouseClicked(evt);
    }
    });
    jMenuItem1.addActionListener(new java.awt.event.ActionListener() {
    public void actionPerformed(java.awt.event.ActionEvent evt) {
    jMenuItem1ActionPerformed(evt);
    }
    });

    jMenu1.add(jMenuItem1);

    jMenuItem2.setLabel("\u062c\u0633\u062a\u062c\u064 8 \u06a9\u062a\u0627\u0628");
    jMenuItem2.addActionListener(new java.awt.event.ActionListener() {
    public void actionPerformed(java.awt.event.ActionEvent evt) {
    jMenuItem2ActionPerformed(evt);
    }
    });

    jMenu1.add(jMenuItem2);

    jMenuItem3.setText("\u0628\u062e\u0634 \u0645\u062f\u06cc\u0631\u06cc\u062a");
    jMenu1.add(jMenuItem3);

    jMenuItem4.setText("Exit");
    jMenuItem4.addActionListener(new java.awt.event.ActionListener() {
    public void actionPerformed(java.awt.event.ActionEvent evt) {
    jMenuItem4ActionPerformed(evt);
    }
    });

    jMenu1.add(jMenuItem4);

    jMenuBar1.add(jMenu1);

    setJMenuBar(jMenuBar1);

    javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(
    layout.createParallelGroup(javax.swing.GroupLayout .Alignment.LEADING)
    .addGroup(layout.createSequentialGroup()
    .addContainerGap(27, Short.MAX_VALUE)
    .addComponent(jLabel11)
    .addGap(18, 18, 18))
    .addGroup(layout.createSequentialGroup()
    .addGap(119, 119, 119)
    .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    .addContainerGap(115, Short.MAX_VALUE))
    );
    layout.setVerticalGroup(
    layout.createParallelGroup(javax.swing.GroupLayout .Alignment.LEADING)
    .addGroup(layout.createSequentialGroup()
    .addGap(21, 21, 21)
    .addComponent(jLabel11)
    .addGap(34, 34, 34)
    .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
    .addContainerGap(50, Short.MAX_VALUE))
    );
    pack();
    }// </editor-fold>

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
    try {
    SecureRandom rand = new SecureRandom( );

    Class.forName("com.sqlserver.jdbc.Driver").newInst ance();

    conn = DriverManager.getConnection(url);

    stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITI VE, ResultSet.CONCUR_UPDATABLE);
    stmt.executeUpdate("CREAT TABLE member"+
    "first name CHAR(15) NOT NULL"+
    "last name CHAR(15) NOT NULL"+
    "name pedar CHAR(15)"+
    "member code CHAR(8) NOT NULL PRIMARY KEY"+
    "member date CHAR(8)"+
    "balance CHAR(8)"+
    "sh.sh CHAR(10)"+
    "birth CHAR(8)"+
    "pass CHAR(4) NOT NULL");

    String fname=jTextField1.getText();
    String lname=jTextField2.getText();
    String mdate=jTextField5.getText();
    String sh=jTextField4.getText();
    char[] pas=jPasswordField2.getPassword();
    String birth=jTextField4.getText();
    String pname=jTextField3.getText();
    int mcod=rand.nextInt(8);
    if ((fname.length()>0)&(pas.length>0)&(sh.length()>0) &(lname.length()>0)){
    String query="INSERT INTO member"+
    "VALUES(fname,lname,pname,mcod,mdate,,sh,birth,pas s)";
    stmt.executeUpdate(query);
    }
    }
    catch (ClassNotFoundException ex) {
    System.out.println("Exception: " + ex.getMessage());
    }catch(InstantiationException ex){
    System.out.println("Exception: " + ex.getMessage());
    }catch(IllegalAccessException ex){
    System.out.println("Exception: " + ex.getMessage());
    }catch(SQLException ex){
    System.out.println("Exception: " + ex.getMessage());
    }

    }

    private void jMenuItem4ActionPerformed(java.awt.event.ActionEve nt evt) {
    System.exit(0);
    }

    private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
    JOptionPane.showMessageDialog(null,"shoma ba moafaghiat vared shodid ","massage",JOptionPane.INFORMATION_MESSAGE);
    }

    private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
    JInternalFrame frame1 = new JInternalFrame();
    Icon icon = null;
    Object[] possibilities = {"writer name", "translator", "subject" ,"Title"};
    String s =(String)JOptionPane.showInputDialog(frame1,"Searc h by:","searching metod",JOptionPane.PLAIN_MESSAGE,icon,possibilitie s,"writer name");

    //If a string was returned, say so.
    if ((s != null) && (s.length() > 0)) {
    jLabel10.setText(s);
    return;
    }
    }

    private void jMenuItem2ActionPerformed(java.awt.event.ActionEve nt evt) {
    look.setSize(530,380);
    look.setVisible(true);
    JInternalFrame frame1 = new JInternalFrame();
    Icon icon = null;
    Object[] possibilities = {"writer name", "translator", "subject" ,"Title"};
    String s =(String)JOptionPane.showInputDialog(frame1,"Searc h by:","searching metod",JOptionPane.PLAIN_MESSAGE,icon,possibilitie s,"writer name");

    //If a string was returned, say so.
    if ((s != null) && (s.length() > 0)) {
    jLabel10.setText(s);
    return;
    }
    }

    private void jMenuItem1ActionPerformed(java.awt.event.ActionEve nt evt) {
    sabt.setSize(530,380);
    sabt.setVisible(true);
    }

    private void jMenuItem1MouseClicked(java.awt.event.MouseEvent evt) {

    }

    private void jMenu1ActionPerformed(java.awt.event.ActionEvent evt) {


    }

    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) {
    java.awt.EventQueue.invokeLater(new Runnable() {
    public void run() {
    new LibraryApp().setVisible(true);
    }
    });
    }

  2. #2

    نقل قول: نوشتن برنامه در نت بینز برای یک db در sql server لطفا کمک کنین خیلی مهمه !!!!

    خودم یاد گرفتم

قوانین ایجاد تاپیک در تالار

  • شما نمی توانید تاپیک جدید ایجاد کنید
  • شما نمی توانید به تاپیک ها پاسخ دهید
  • شما نمی توانید ضمیمه ارسال کنید
  • شما نمی توانید پاسخ هایتان را ویرایش کنید
  •