Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package mysqlconnector;
- import java.awt.*;
- import java.awt.event.*;
- import java.applet.Applet;
- import java.sql.*;
- import java.util.*;
- public class beat extends Applet implements ActionListener
- {
- public static TextArea area;
- public static String text;
- public static String outText;
- public static TextField field;
- public static String command;
- public static String strSQL;
- public static Connection con;
- public static ResultSet result;
- public static Font TimesR = new Font("MonoSpaced", Font.BOLD, 15);
- public void init()
- {
- setLayout( new BorderLayout() );
- add( "Center", area = new TextArea() );
- area.setFont(TimesR);
- area.setText("***** Welcome to the Java Text RPG! *****\n");
- area.setEditable(false);
- add( "South", field = new TextField() );
- field.addActionListener ( this );
- field.requestFocusInWindow();
- }
- public void connectMySQL() {
- try
- {
- Class.forName("org.gjt.mm.mysql.Driver");
- Properties props = new Properties();
- props.put("user", "root");
- Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/jgame", props);
- area.append("Database is connected!\n");
- PreparedStatement statement = con.prepareStatement( "select * from members");
- ResultSet result = statement.executeQuery();
- while(result.next())
- {
- area.append(result.getString(2)+ "\n");
- }
- }
- catch(Exception err)
- {
- }
- }
- public void start() {
- connectMySQL();
- }
- public static void appendIt() {
- String text = field.getText();
- area.append("> "+field.getText() + "\n");
- // STATUS *************************************************
- if ("status".equalsIgnoreCase(text)) {
- area.append("Checking status..."); //add onto text area
- try {
- if (!con.isClosed()) {
- area.append("\n > ONLINE");
- }else {
- area.append("\n > OFFLINE");
- }
- }catch (Exception eer) {
- area.append("\nSQL Error: " + eer.toString() + "\nGet Local Msg: " + eer.getLocalizedMessage()); //add onto text area
- }
- // END STATUS *************************************************
- }
- }
- public void actionPerformed(ActionEvent e)
- {
- connectMySQL();
- appendIt();
- if (con == null) {
- area.append("> OFFLINE\n");
- }else {
- area.append("> ONLINE\n");
- }
- field.setText(""); // clear input box
- }
- public void stop()
- {
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement