java删除会员信息_java代码 用户信息修改与删除.doc

java代码 用户信息修改与删除

package tushuguanli;

import java.awt.*;

import java.awt.event.*;

import java.util.*;

import javax.swing.*;

import java.awt.*;

import javax.swing.table.*;

import java.util.*;

import javax.swing.tree.DefaultMutableTreeNode;

import javax.swing.tree.DefaultTreeModel;

import javax.swing.tree.TreeSelectionModel;

import javax.swing.ButtonGroup;

import java.sql.DriverManager;

import java.sql.Connection;

import java.sql.CallableStatement;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.Statement;

import java.awt.*;

import java.awt.event.*;

import javax.swing.*;

import javax.swing.event.*;

public class Yhxxxgysc {

/**

* @param args

*/

public static void main(String[] args)

{

Yhxxxgysc_1 frame=new Yhxxxgysc_1();

frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

frame.setVisible(true);

}

}

class Yhxxxgysc_1 extends JFrame

{

private static final int AUTO_RESIZE_OFF=0;

Yhxxxgysc_1()

{

setTitle("用户信息修改与删除");

setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);

setVisible(true);

Toolkit tk = Toolkit.getDefaultToolkit();

Dimension screenSize = tk.getScreenSize();

int screenHeight = screenSize.height;

int screenWidth = screenSize.width;

setSize(screenWidth, screenHeight);

Container contentPane = getContentPane();

setLocationRelativeTo(null);

contentPane.setLayout(null);

myTable=new DefaultTableModel();

try{

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

conn=DriverManager.getConnection("jdbc:sqlserver://localhost:53104;DatabaseName=tushuguan;",

"sa", "123");

stmt=conn.createStatement();

rs=stmt.executeQuery("select * from yhxx");//xx为自己建的表的名称

ResultSetMetaData metaData;

metaData = rs.getMetaData();

number=metaData.getColumnCount();

columnNames=new Vector();

rows=new Vector>();

for(int num=0;num

{

columnNames.addElement(metaData.getColumnLabel(num