package com.test;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import java.sql.*;public class Manage extends JFrame{
JButton jb3,jb1,jb2,jb;
JPanel jp1,jp2;
JTextField jtf;
JLabel jl1;
JTable jt;
Vector row,column;
Connection ct;
ResultSet rs;
PreparedStatement ps;
JScrollPane jsp;
public static void main(String[] args) {
// TODO Auto-generated method stub
Manage mm=new Manage();
mm.setVisible(true);
}
public Manage()
{
setSize(400,300);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setTitle("student manage System");
//UP part
jl1=new JLabel("请输入名字");
jtf=new JTextField(10);
jb=new JButton("确定");
jp1=new JPanel();
jp1.add(jl1);
jp1.add(jtf);
jp1.add(jb);
this.add(jp1,"North");
//down part
jb1=new JButton("添加");
jb2=new JButton("删除");
jb3=new JButton("修改");
jp2=new JPanel();
jp2.add(jb1);
jp2.add(jb2);
jp2.add(jb3);
this.add(jp2,"South");
//center part
//添加列名
column=new Vector();
column.add("学好");
column.add("姓名");
column.add("籍贯");
//添加行数据
row=new Vector();
Vector hang=new Vector();
try{
//1.loding driver
Class.forName("com.mysql.jdbc.Driver");
ct=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/temp","hongming","785006136");
ps=ct.prepareStatement("select * from student");
rs=ps.executeQuery();
if(rs.next())
{
hang.add(rs.getString(1));
hang.add(rs.getString(2));
hang.add(rs.getString(3));
row.add(hang);
}
}catch(Exception e)
{
e.printStackTrace();
}finally
{
try{
if(rs!=null)rs.close();
if(ps!=null)ps.close();
if(ct!=null)ct.close();
}catch(Exception e)
{
e.printStackTrace();
}
}
jt=new JTable(row,column);
jsp=new JScrollPane(jt);
this.add(jsp);
}}
出错如下:java.sql.SQLException: Access denied for user 'hongming'@'localhost' (using password: YES)
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import java.sql.*;public class Manage extends JFrame{
JButton jb3,jb1,jb2,jb;
JPanel jp1,jp2;
JTextField jtf;
JLabel jl1;
JTable jt;
Vector row,column;
Connection ct;
ResultSet rs;
PreparedStatement ps;
JScrollPane jsp;
public static void main(String[] args) {
// TODO Auto-generated method stub
Manage mm=new Manage();
mm.setVisible(true);
}
public Manage()
{
setSize(400,300);
this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
this.setTitle("student manage System");
//UP part
jl1=new JLabel("请输入名字");
jtf=new JTextField(10);
jb=new JButton("确定");
jp1=new JPanel();
jp1.add(jl1);
jp1.add(jtf);
jp1.add(jb);
this.add(jp1,"North");
//down part
jb1=new JButton("添加");
jb2=new JButton("删除");
jb3=new JButton("修改");
jp2=new JPanel();
jp2.add(jb1);
jp2.add(jb2);
jp2.add(jb3);
this.add(jp2,"South");
//center part
//添加列名
column=new Vector();
column.add("学好");
column.add("姓名");
column.add("籍贯");
//添加行数据
row=new Vector();
Vector hang=new Vector();
try{
//1.loding driver
Class.forName("com.mysql.jdbc.Driver");
ct=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/temp","hongming","785006136");
ps=ct.prepareStatement("select * from student");
rs=ps.executeQuery();
if(rs.next())
{
hang.add(rs.getString(1));
hang.add(rs.getString(2));
hang.add(rs.getString(3));
row.add(hang);
}
}catch(Exception e)
{
e.printStackTrace();
}finally
{
try{
if(rs!=null)rs.close();
if(ps!=null)ps.close();
if(ct!=null)ct.close();
}catch(Exception e)
{
e.printStackTrace();
}
}
jt=new JTable(row,column);
jsp=new JScrollPane(jt);
this.add(jsp);
}}
出错如下:java.sql.SQLException: Access denied for user 'hongming'@'localhost' (using password: YES)
解决方案 »
- Struts2 Weblogic 的问题!急急,在线等!
- SSH的子查询问题,很急求各位大哥大姐 支招
- 如何进行文本排版
- 推荐一本学习spring的书 急!
- sessionbean+hibernate中,是否bean中每个方法都新建一个session呢?
- 为何没有结果显示出来
- 紧急求救:java.net.SocketException: Connection reset by peer: socket write error
- 100分:初次接触webservice,通过soap调用webservice。有几点不明,望高手指点:
- 如何获取计算机名
- 各位做过J2EE开发的来说说:为编码阶段做准备,需要学习哪些技术?
- 请问hibernate防止SQL注入的原理是怎么样的
- Java 服务器端与客户端
然后我连接他的时候用hongming就不对呢,我改用root就对了。为什么啊,mysq初学