jdbcmodifydemo.java

里面所含源码是本人平时做程序的一些实例

import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.io.*;
import java.sql.*;
public class JdbcModifyDemo extends JFrame implements ActionListener
{
	JPanel pnlMain;
	JLabel lblName,lblPass;
	JTextField txtName,txtPass;
	JButton btnInsert,btnSave,btnUpdate,btnDelete;
	//构造函数
	public JdbcModifyDemo()
	{
		//初始化组件
		super("JDBC插入、修改和删除演示");
		pnlMain= new JPanel();
		lblName=new JLabel("用户名：");
		lblPass=new JLabel("密  码：");
		txtName=new JTextField(20);
		txtPass=new JTextField(20);
		btnInsert=new JButton("插入");
		btnInsert.addActionListener(this);
		btnSave=new JButton("保存");
		btnSave.setEnabled(false);
		btnSave.addActionListener(this);
		btnUpdate=new JButton("修改");
		btnUpdate.addActionListener(this);
		btnDelete=new JButton("删除");
		btnDelete.addActionListener(this);
		//添加组件
		pnlMain.add(lblName);
		pnlMain.add(txtName);
		pnlMain.add(lblPass);
		pnlMain.add(txtPass);
		pnlMain.add(btnInsert);
		pnlMain.add(btnSave);
		pnlMain.add(btnUpdate);
		pnlMain.add(btnDelete);
		setContentPane(pnlMain);
		setSize(300,150);
		setVisible(true);
		this.setDefaultCloseOperation(3);
	}
	//按钮监听
	public void actionPerformed(ActionEvent ae)
	{
		if(ae.getSource()==btnInsert)
			initComponent();
		if(ae.getSource()==btnSave)
			saveRecord();
		if(ae.getSource()==btnUpdate)
			updateRecord();
		if(ae.getSource()==btnDelete)
		{
			int intChoice=JOptionPane.showConfirmDialog(null,"真的要删除记录吗？","确认删除",JOptionPane.YES_NO_OPTION);
			if(intChoice==0)
			{
				deleteRecord();
			}
		}
	}
	//调用方法创建连接
	public Connection openDatabase()
	{
		String url="jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=HappyChat";
		try
		{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			Connection conn=DriverManager.getConnection(url,"sa","");
			System.out.println ("连接成功");
			return conn;
		}
		catch(Exception e)
		{
			JOptionPane.showMessageDialog(null,"连接数据库失败！");
			return null;
		}
	}
	//初始化文本组件
	public void initComponent()
	{
		txtName.setText("");
		txtPass.setText("");
		btnSave.setEnabled(true);
	}
	//保存记录
	public void saveRecord()
	{
		try
		{
			PreparedStatement psm=openDatabase().prepareStatement("Insert into users(U_Name,U_Pass) values(?,?)");
			psm.setString(1,txtName.getText());
			psm.setString(2,txtPass.getText());
			psm.executeUpdate();
			JOptionPane.showMessageDialog(null,"记录保存成功！");
			psm.close();
		}
		catch(Exception e)
		{
			JOptionPane.showMessageDialog(null,"记录插入失败！");
			
		}
	}
	//更新记录
	public void updateRecord()
	{
		try
		{
			Statement sm=openDatabase().createStatement();
			String strUpdate="update users set U_Pass='"+txtPass.getText()+"' where U_Name='"+txtName.getText()+"'";
			sm.executeUpdate(strUpdate);
			JOptionPane.showMessageDialog(null,"记录修改成功！");
			sm.close();
		}
		catch(Exception e)
		{
			JOptionPane.showMessageDialog(null,"记录修改失败！");
		}
	}
	//删除记录
	public void deleteRecord()
	{
		try
		{
			Statement stm=openDatabase().createStatement();
			stm.executeUpdate("delete from users where U_Name='"+txtName.getText()+"'");
			JOptionPane.showMessageDialog(null,"记录删除成功！");
			stm.close();
		}
		catch(Exception e)
		{
			JOptionPane.showMessageDialog(null,"记录删除失败！");
		}
	}
	/**
	 * Method main
	 *
	 *
	 * @param args
	 *
	 */
	public static void main(String[] args) {
		new JdbcModifyDemo();
	}
	
	
}