databasetest.java

jsp链接sqlserver2005的实例代码

package DataBase_Link;

import java.awt.BorderLayout;
import java.awt.Component;
import java.awt.Container;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextArea;
import javax.swing.JTextField;


public class DatabaseTest extends JFrame{
	
	private String User = "sa";
	private String Password = "123456";
	private String URL = null;
	private Connection con = null;
	private Statement stmt;
    private ResultSet rs = null;
    private String sql = null;
    private boolean falg = false;
	
	String[] Items = {"SqlServer2005","Oracle"};
	JPanel[] pane = new JPanel[6];
	JButton button1 = new JButton("查询");
	JButton button2 = new JButton("增加");
	JButton button3 = new JButton("删除");
	JButton button4 = new JButton("修改");
	JTextArea text = new JTextArea();
	JTextField text1 = new JTextField(6);
	JTextField text2 = new JTextField(6);
	JTextField text3 = new JTextField(6);
	JLabel label = new JLabel("请选择要连接的数据库:");
	JLabel label1 = new JLabel("结果显示区:");
	JLabel labela = new JLabel("编号:");
	JLabel labelb = new JLabel("用户名:");
	JLabel labelc = new JLabel("密码:");
	JComboBox combox = new JComboBox(Items);
	
	public DatabaseTest(){
		super("数据库连接");
		Container panes=getContentPane();
		panes.setLayout(new BorderLayout());
		
		for(int i = 0;i < 6;i ++){
			pane[i] = new JPanel();
			pane[i].addMouseListener(new mouse_event());
		}
		button1.addActionListener(new buttons());
		button2.addActionListener(new buttons());
		button3.addActionListener(new buttons());
		button4.addActionListener(new buttons());
			
		
		pane[0].setLayout(new FlowLayout());
		pane[0].add(label);
		pane[0].add(combox);
		
		pane[1].setLayout(new GridLayout(2,1));
		pane[2].setLayout(new BorderLayout());
		pane[2].add(label1,BorderLayout.NORTH);
		pane[2].add(text);
		
		pane[3].setLayout(new GridLayout(2,1));
		pane[3].add(pane[5]);
		pane[4].setLayout(new GridLayout(1,4));
		pane[4].add(button1);
		pane[4].add(button2);
		pane[4].add(button3);
		pane[4].add(button4);
		
		pane[5].setLayout(new FlowLayout());
		pane[5].add(labela);
		pane[5].add(text1);
		pane[5].add(labelb);
		pane[5].add(text2);
		pane[5].add(labelc);
		pane[5].add(text3);
		pane[3].add(pane[4]);
		
		pane[1].add(pane[2]);
		pane[1].add(pane[3]);
		panes.add(pane[0],BorderLayout.NORTH);
		panes.add(pane[1]);
		panes.add(new JPanel(),BorderLayout.WEST);
		panes.add(new JPanel(),BorderLayout.EAST);
		panes.add(new JPanel(),BorderLayout.SOUTH);
		setContentPane(panes);
		text.setEditable(false);         //文本框为只读
		setSize(400,300);
		setVisible(true);
	}
	
	
	/**
	 * 方法名称:内部类名buttons
	 * 方法作用:处理所有button事件
	 * 形参名称：无
	 * 形参类型:无
	 * 形参作用:无
	 * 返回结果:void
	 *    作者:王晓雷
	 *    日期:2008-8-31
	 * **/
	class buttons implements ActionListener{
		public void actionPerformed(ActionEvent e){
			if(e.getSource() == button1){
				falg = true;
				sql = "SELECT * FROM TESTTABLE";
			}else if(e.getSource() == button2){
				sql = "INSERT INTO TESTTABLE VALUES('" + text1.getText().trim() 
				+ "','" + text2.getText().trim() + "','" + text3.getText().trim() + "')";
			}else if(e.getSource() == button3){
				sql = "DELETE FROM TESTTABLE WHERE NUM = '"+ text1.getText().trim() +"'";
			}else if(e.getSource() == button4){
				sql = "UPDATE TESTTABLE Set Num = '" + text1.getText().trim() 
				+ "',NAME = '"+ text2.getText().trim() +"',PASSWORD = '"+ text3.getText().trim() 
				+"'  WHERE Num = '"+ text1.getText().trim() +"'";
			}
			if(combox.getSelectedIndex() == 0){
				SQLServer_DatabaseLink();
			}else{
				Oracle_DatabaseLink();
			}
		}
	}
	
	
	
	/**
	 * 方法名称:内部类名mouse_Event
	 * 方法作用:处理所有鼠标事件
	 * 形参名称：无
	 * 形参类型:无
	 * 形参作用:无
	 * 返回结果:void
	 *    作者:王晓雷
	 *    日期:2008-8-31
	 * **/
	class mouse_event implements MouseListener{
		public void mouseClicked(MouseEvent event) {
			if(event.getButton() == MouseEvent.BUTTON3){
				RightEvent re = new RightEvent();
				for(int i = 0;i < 6; i ++){
					if(event.getSource() == pane[i]){
						re.show((Component)pane[i],event.getX(),event.getY());
					}
				}
			}			
		}
		public void mouseEntered(MouseEvent arg0) {}
		public void mouseExited(MouseEvent arg0) {}
		public void mousePressed(MouseEvent arg0) {}
		public void mouseReleased(MouseEvent arg0) {}
	}

	
	/**
	 * 方法名称:DatabaseLink
	 * 方法作用:执行ORACLE数据库所有操作
	 * 形参名称：DataBaseName,sql
	 * 形参类型:无
	 * 形参作用:无
	 * 返回结果:void
	 *    作者:王晓雷
	 *    日期:2008-8-31
	 * **/
	public void Oracle_DatabaseLink(){
		try{
			URL = "jdbc:oracle:oci:@STUDENT_SERV";
			Class.forName("oracle.jdbc.driver.OracleDriver");
			con = DriverManager.getConnection(URL,"WXL","888888");
			stmt = con.createStatement();
			stmt.execute(sql);          //执行SQL语句
			if(falg){
				falg = false;
				rs = stmt.getResultSet();   //获取数据结果
				text.setText("编号\t用户\t密码\n");
				while(rs.next()){
					text.setText(text.getText()+ rs.getString("NUM") + 
							"\t"+ rs.getString("NAME") + "\t"+ rs.getString("PASSWORD") + "\n");
				}
				JOptionPane.showMessageDialog(null,"查询成功","提示",JOptionPane.INFORMATION_MESSAGE);
			}else{
				JOptionPane.showMessageDialog(null,"操作成功","提示",JOptionPane.INFORMATION_MESSAGE);
			}
		}catch(ClassNotFoundException e){
			System.out.println("错误!");
			e.printStackTrace();
		}catch(NullPointerException e){
			
		}catch(SQLException e){
			System.out.println(e);
		}
	}
	
	
	/**
	 * 方法名称:SQLServer_DatabaseLink
	 * 方法作用:执行SQLServer数据库所有操作
	 * 形参名称：无
	 * 形参类型:无
	 * 形参作用:无
	 * 返回结果:void
	 *    作者:王晓雷
	 *    日期:2008-8-31
	 * **/
	public void SQLServer_DatabaseLink(){
		try{
			URL = "jdbc:sqlserver://localhost:1433;DatabaseName=TEST";
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			con = DriverManager.getConnection(URL, "sa", "123456");
			stmt = con.createStatement();
			stmt.execute(sql);
			if(falg){
				falg = false;
				rs = stmt.getResultSet();
				text.setText("编号\t用户\t密码\n");
				while(rs.next()){
					text.setText(text.getText()+ rs.getString("NUM") + 
							"\t"+ rs.getString("NAME") + "\t"+ rs.getString("PASSWORD") + "\n");
				}
				JOptionPane.showMessageDialog(null,"查询成功","提示",JOptionPane.INFORMATION_MESSAGE);
			}else{
				JOptionPane.showMessageDialog(null,"操作成功","提示",JOptionPane.INFORMATION_MESSAGE);
			}
		}catch(ClassNotFoundException e){
			e.printStackTrace();
		}catch(NullPointerException e){
			
		}catch(SQLException e){
			System.out.println(e);
		}
	}
	
	
	
	public static void main(String[] args){
		new DatabaseTest();
	}


	public void mouseEntered(MouseEvent arg0) {
		// TODO Auto-generated method stub
		
	}


	public void mouseExited(MouseEvent arg0) {
		// TODO Auto-generated method stub
		
	}


	public void mousePressed(MouseEvent arg0) {
		// TODO Auto-generated method stub
		
	}


	public void mouseReleased(MouseEvent arg0) {
		// TODO Auto-generated method stub
		
	}

}