📄 datamanage.java
字号:
/*
* Created 2008-9-19
*/
package fbms;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import javax.swing.JComboBox;
import javax.swing.table.DefaultTableModel;
public class DataManage
{
static Connection conn;
static Statement stmt;
static ResultSet rs;
public static DefaultTableModel getModel(String tableName,String[] col,String[] values,String[] headers)
{
String[] formatHeaders = new String[headers.length];
for(int i = 0;i<headers.length;i++)
{
formatHeaders[i] = "<html><b>"+headers[i]+"</html></b>";
}
DefaultTableModel model = new DefaultTableModel(null, formatHeaders)
{
public boolean isCellEditable(int row, int column)
{
return false;
}
};
String str = "select * from "+tableName;
if(col != null && values!= null)
{
str+=" where ";
for(int i = 0;i<values.length;)
{
str+=col[i]+" like '"+values[i]+"%'";
i++;
if(i < values.length) str+=" and " ;
}
}
try
{
rs=stmt.executeQuery(str);
String[] string = new String[headers.length];
while(rs.next())
{
for(int i = 0;i<headers.length;i++)
{
string[i] = rs.getString(headers[i]);
}
model.addRow(string);
}
}
catch(SQLException se)
{
System.out.println("SORRY1，连接数据库失败.....");
}
return model;
}
public static void addData(String tableName,Object[] object)
{
try
{
String s = "insert into "+tableName+" values (";
for(int i = 0;i<object.length;)
{
s+="'"+object[i]+"'";
i++;
if(i != object.length)
s+=",";
}
s+=")";
System.out.println(s);
stmt.executeUpdate(s);
}
catch(SQLException sqlE)
{
System.out.println("添加失败");
}
}
public static void deleteData(String tableName,String col,String vaule)
{
String str = "delete from "+tableName+" where "+col+" = '"+vaule+"'";
try
{
stmt.execute(str);
}
catch(SQLException sqle)
{
System.out.println("delete is failed!");
}
}
public static void updateData(String tableName,String[] col,String[] values,String colName,String selectName)
{
String str = "update "+tableName+" set ";
for(int i = 0;i<values.length;)
{
str+=col[i]+" = '"+values[i]+"'";
i++;
if(i < values.length) str+="," ;
}
str+=" where "+ colName +" = '"+selectName+"'";
try
{
stmt.executeUpdate(str);
}
catch(SQLException sqle)
{
System.out.println("update is failed!");
}
}
public static String[] selectData(String tableName,String colName,String selectName)
{
String str = "select * from "+tableName+" where "+colName+" like '"+selectName+"%'";
try
{
rs=stmt.executeQuery(str);
if(rs.next())
{
return new String[]{ rs.getString(1),rs.getString(2),rs.getString(3) };
}
}
catch(SQLException sqle)
{
System.out.println("hasData is failed!");
}
return null;
}
public static ArrayList selectData(String sql)
{
try
{
String[] str;
rs=stmt.executeQuery(sql);
ArrayList list = new ArrayList();
while(rs.next())
{
list.add(rs.getString(1));
}
return list;
}
catch(SQLException sqle)
{
System.out.println("hasData is failed!");
}
return null;
}
static
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:BELL;databaseName=splendour","hui","123455");
stmt=conn.createStatement();
}
catch(ClassNotFoundException ce)
{
System.out.println("SORRY,加载数据库失败.....");
}
catch(SQLException se)
{
System.out.println("SORRY，连接数据库失败.....");
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -