?? sample2.java
字號:
import java.io.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class Sample2 extends JFrame
{
JPanel jp;
JLabel l,l1,l2,l3;
JTextField jt,jt1,jt2,jt3;
JButton jb,jb1,jb2;
public Sample2()
{
jp=new JPanel();
getContentPane().add(jp);
jp.setLayout(null);
l=new JLabel("Sno");
jp.add(l);
l.setBounds(25,20,60,60);
l1=new JLabel("Sname");
jp.add(l1);
l1.setBounds(25,50,80,80);
l2=new JLabel("Address");
jp.add(l2);
l2.setBounds(25,90,80,80);
l3=new JLabel("Email");
jp.add(l3);
l3.setBounds(25,130,80,80);
jt=new JTextField();
jp.add(jt);
jt.setBounds(90,40,100,20);
jt1=new JTextField();
jp.add(jt1);
jt1.setBounds(90,80,100,20);
jt2=new JTextField();
jp.add(jt2);
jt2.setBounds(90,120,100,20);
jt3=new JTextField();
jp.add(jt3);
jt3.setBounds(90,160,100,20);
jb=new JButton("Insert");
jp.add(jb);
jb.setBounds(50,200,70,20);
jb1=new JButton("Clear");
jp.add(jb1);
jb1.setBounds(130,200,70,20);
jb2=new JButton("Exit");
jp.add(jb2);
jb2.setBounds(220,200,70,20);
setSize(500,500);
setTitle("Insert the data");
setVisible(true);
//setEnabled(true);
setDefaultCloseOperation(EXIT_ON_CLOSE);
jb.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae)
{
//String str=jt.getText();
int s=Integer.parseInt(jt.getText());
String s1=jt1.getText();
String s2=jt2.getText();
String s3=jt3.getText();
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:sample");
String vsql="insert into stable values(?,?,?,?)";
PreparedStatement pstmt=con.prepareStatement(vsql);
pstmt.setInt(1,s);
pstmt.setString(2,s1);
pstmt.setString(3,s2);
pstmt.setString(4,s3);
pstmt.executeUpdate();
JOptionPane.showMessageDialog(null,"Data INSERTED");
System.out.println("data inserted");
}catch(Exception e)
{
System.out.println(e);
}
}
});
jb1.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e)
{
jt.setText("");
jt1.setText("");
jt2.setText("");
jt3.setText("");
}
});
jb2.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent ae)
{
System.exit(0);
}
});
}
public static void main(String[] args)
{
new Sample2();
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -