这样运行看看:package mybean;import java.io.*;
import java.sql.*;public class connbean {
private String pdm="";
public void setPdm(String pdm){
this.pdm=pdm;
}
public String getPdm(){
private String driverName="com.mysql.jdbc.Driver";
private String username="root";
private String password="x7u7w2e1i4";
private String dbname="study";
private String tableName="product";
}
public connbean()
{
try{
Class.forName("com.mysql.jdbc.Driver");
}catch(Exception e){} try{
String url="jdbc:mysql://localhost/"+dbname+"? useUnicode=true&characterEncoding=gb2312&user="+username+"&password="+password;
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
String sql="SELECT * FROM"+tableName;
ResultSet rs = statement.executeQuery(sql);
String pdm=rs.getString("pdm");
System.out.println("pdm");
rs.close();
statement.close();
connection.close();
}catch(SQLException e){}
return ;
}
}
import java.sql.*;public class connbean {
private String pdm="";
public void setPdm(String pdm){
this.pdm=pdm;
}
public String getPdm(){
private String driverName="com.mysql.jdbc.Driver";
private String username="root";
private String password="x7u7w2e1i4";
private String dbname="study";
private String tableName="product";
}
public connbean()
{
try{
Class.forName("com.mysql.jdbc.Driver");
}catch(Exception e){} try{
String url="jdbc:mysql://localhost/"+dbname+"? useUnicode=true&characterEncoding=gb2312&user="+username+"&password="+password;
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
String sql="SELECT * FROM"+tableName;
ResultSet rs = statement.executeQuery(sql);
String pdm=rs.getString("pdm");
System.out.println("pdm");
rs.close();
statement.close();
connection.close();
}catch(SQLException e){}
return ;
}
}
import java.sql.*;public class connbean {
private String pdm="";
private String driverName="com.mysql.jdbc.Driver";
private String username="root";
private String password="x7u7w2e1i4";
private String dbname="study";
private String tableName="product"; public void setPdm(String pdm){
this.pdm=pdm;
}
public String getPdm(){
return this.pdm;
}
public connbean()
{
try{
Class.forName("com.mysql.jdbc.Driver");
}catch(Exception e){} try{
String url="jdbc:mysql://localhost/"+dbname+"? useUnicode=true&characterEncoding=gb2312&user="+username+"&password="+password;
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
String sql="SELECT * FROM"+tableName;
ResultSet rs = statement.executeQuery(sql);
this.pdm=rs.getString("pdm");
System.out.println("pdm");
rs.close();
statement.close();
connection.close();
}catch(SQLException e){}
}
}
String url="jdbc:mysql://localhost/"+dbname+"? useUnicode=true&characterEncoding=gb2312&user="+username+"&password="+password;
这句问好后面多了一个空格。