ensiyehh
شنبه 21 آبان 1390, 20:52 عصر
سلام یه پروژه دانشگاه باید انجام بدم که باید برای پایگاه داده در 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\u0648 \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").newInstance();
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,pass )";
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,"Search by:","searching metod",JOptionPane.PLAIN_MESSAGE,icon,possibilities,"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,"Search by:","searching metod",JOptionPane.PLAIN_MESSAGE,icon,possibilities,"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);
}
});
}
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\u0648 \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").newInstance();
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,pass )";
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,"Search by:","searching metod",JOptionPane.PLAIN_MESSAGE,icon,possibilities,"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,"Search by:","searching metod",JOptionPane.PLAIN_MESSAGE,icon,possibilities,"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);
}
});
}