58,452
社区成员




import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
try
{
Class.forName("org.gjt.mm.mysql.Driver");
}
catch(ClassNotFoundException error)
{
JOptionPane.showMessageDialog(this, "MySQL数据库驱动检索失败!程序无法链接到数据库!", "错误提示", JOptionPane.WARNING_MESSAGE);
}
text.setText("查询结果:\n");
try
{
con=DriverManager.getConnection("jdbc:MySQL://127.0.0.1:3306/Phone_Contacts", "root","000000");
if(radio_name.isSelected())
{
pre=con.prepareStatement("SELECT DISTINCT * FROM Contact WHERE name Like '"+field_name.getText()+"%'");
}
else if(radio_phone.isSelected())
{
pre=con.prepareStatement("SELECT DISTINCT * FROM Contact WHERE mobile Like '"+field_phone.getText()+"%'");
}
rs=pre.executeQuery();
row=new CachedRowSetImpl();
row.populate(rs);
con.close();
if(!row.next())
{
text.append("Sorry,无此记录!\n");
}
else
{
row.beforeFirst();
while(row.next())
{
text.append(row.getString(1)+"\t");
text.append(row.getString(2)+"\n");
}
}
}
catch (SQLException error)
{
System.out.println("error!");
}